Hi There,
I am trying to find an easier way to add a new series to my charts, while it is easier to do that for one worksheet I have around 150 worksheets in one excel file with the same data and a graph on each worksheet but for different business units so every time I have to change anything it becomes few hours task as I have to go in individual worksheet and make that change even if I use Macros. I tried by grouping all the worksheet together and inserting a new line in between the current data, excel will automatically update the data selection but apparently not.
Is there any way I can group all and add new data for my line chart .
Thank you in advance..
I am trying to find an easier way to add a new series to my charts, while it is easier to do that for one worksheet I have around 150 worksheets in one excel file with the same data and a graph on each worksheet but for different business units so every time I have to change anything it becomes few hours task as I have to go in individual worksheet and make that change even if I use Macros. I tried by grouping all the worksheet together and inserting a new line in between the current data, excel will automatically update the data selection but apparently not.
Is there any way I can group all and add new data for my line chart .
Thank you in advance..