Multiple Graphs

[Ross]

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

 

[Jon Peltier]

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/
_______

 

[cs02000]

Keep the orginal data on seperate sheets.
Copy and paste the data into the cells that feed the graph that ar
located on a different sheet