I want to prepare chart for all module.
One chart i prepared for S01 and now the charts will be similar for all modules viz. S1, S2 & S3 with same formatting.
Now i dont want to change it manually by "select data" and change the selection as in this case the modules are only 3 but they could be 100 in some of the cases.
Please help!
Sheet attached for reference.
Thanks in advance.
One chart i prepared for S01 and now the charts will be similar for all modules viz. S1, S2 & S3 with same formatting.
Now i dont want to change it manually by "select data" and change the selection as in this case the modules are only 3 but they could be 100 in some of the cases.
Please help!
Sheet attached for reference.
Thanks in advance.