| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Graph But change Data Sheet
Hi
I have a graph which I do for each Month Jan Graph (tab) Jan data (tab) each month i copy/re-name this to make it Feb Graph, Feb Data, Mar graph etc. However is there any quick way of changing the whole graph and data on the graph to read from a differenct sheet? I am having to manual changed all the data boxs on the graph (=Jun!$B $30) just to read July etc Any ideas??? Linexe |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Graph But change Data Sheet
If the data is manually entered, this is what I would do
Click the tab for July; hold CTRL and drag the tab to the right giving a second copy of the sheet Rename the sheet Now enter the data in the cells of the new sheet and the chart will update. Repeat next month Any use? -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Linexe" wrote in message ... Hi I have a graph which I do for each Month Jan Graph (tab) Jan data (tab) each month i copy/re-name this to make it Feb Graph, Feb Data, Mar graph etc. However is there any quick way of changing the whole graph and data on the graph to read from a differenct sheet? I am having to manual changed all the data boxs on the graph (=Jun!$B $30) just to read July etc Any ideas??? Linexe |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why do dates change when I copy/paste into another sheet? | Excel Discussion (Misc queries) | |||
| How do I copy a graph and use the data in the new worksheet? | Charts and Charting in Excel | |||
| How do I copy a graph to new worksheet and get data from new sheet? | Charts and Charting in Excel | |||
| Bug: Move or Copy sheet graph links not updating! | Excel Discussion (Misc queries) | |||
| when i move or copy a sheet, dates change by one day?? | Excel Discussion (Misc queries) | |||
Hybrid Mode
