Question by athena: Creating graphs on microsoft excel on a different tab?
I know how to create graphs on excel but i want to have these graphs shown on a separate tab.
So i will input all the data on one page in a table. The graphs on the other page should formulate on its own.
If anybody knows how this can be done, please help. I am using Microsoft Office Excel 2003. Thank You!
Answer by Cozmosis
On Step 4 of 4 in the Chart Wizard, you can define what sheet to put your chart on. The chart doesn’t have to be on the same sheet as the data and it will update when you make changes to the data.
You could also create a new “Chart” sheet which is a specific type of sheet with only one chart and nothing else.
If you want to move an existing chart to a different sheet, right-click on the chart and select “Location” from the pop-up menu.
Add your own answer in the comments!