Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Graphs
Hi,
I have to update graphs every second day or so, just now I am doing this manually by sourcing data then changing the dates etc. Each graph is from a different tab spreadsheet in the workbook, but the majority of data has the same row and colums in each tab which it is extracted from ( i.e my firdt series values). This happens in all but one sheet where it is just the rows that differ and the colums stay the same (i.e my second series values). I was wondering if anyone new a simplier and quicker way of doin this as it is tedious and time consuming. Thank you, Ross |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Graphs
Copy the sheet with its embedded chart, then change the data on the copied
worksheet. The chart still points to that range with the new numbers in it. Changing the worksheet data is way faster than changing the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Ross" wrote in message ... Hi, I have to update graphs every second day or so, just now I am doing this manually by sourcing data then changing the dates etc. Each graph is from a different tab spreadsheet in the workbook, but the majority of data has the same row and colums in each tab which it is extracted from ( i.e my firdt series values). This happens in all but one sheet where it is just the rows that differ and the colums stay the same (i.e my second series values). I was wondering if anyone new a simplier and quicker way of doin this as it is tedious and time consuming. Thank you, Ross |
#3
|
|||
|
|||
Keep the orginal data on seperate sheets.
Copy and paste the data into the cells that feed the graph that are located on a different sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Resize Multiple Graphs at Once | Excel Discussion (Misc queries) | |||
How do I put multiple graphs on one axis? | Charts and Charting in Excel | |||
graphs from multiple worksheet : query | Charts and Charting in Excel |