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

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" <[email protected]> wrote in message
news:[email protected]...
> 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

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.


--
cs02000