| 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 |
| 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) | |||
Threaded Mode
