I have a workbook with 50 different tabs but all of the data is organized the exact same way on each tab. Is there a way to select all of the tabs at once and insert/edit a graph?
Thanks.
I have a workbook with 50 different tabs but all of the data is organized the exact same way on each tab. Is there a way to select all of the tabs at once and insert/edit a graph?
Thanks.
No.
You would need to do each one separately. Using VBA code would speed up the process.
Do you really need 50 different charts? Could you not use 1 chart to view data from 1 of the 50 charts at a time using named ranges.
How could one graph work for all of the different tabs?
Each tab is for a different medical group practice that will be shared with the office managers. What I need to do is generate the same graph for each practice. I saved the chart template and have all of the data in the same location on each tab and manually inserted the template in each tab. Is there a easier way to do this?
One graph to view any one of the 50 sheets. Not all 50 sheets in one graph.
You would need to alter the range references of each chart to the sheet it is on. To automate that process you can use VBA.
So assuming Sheet1 contains the original chart object and you copy that to Sheet2. You can use the following to alter the series formula.
Select Sheet2 and goto Immediate window in VBE (ALT+F11 CTRL+G) paste the command and press enter.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks