line graph

#1 05-25-2005, 12:06 PM

I have data from jan 04 through present and each month new data is added to
30 different Areas
I have a line chart for each Area (data on an excel spreadsheet) that needs
to be updated for the twelve month period. (i.e. if i just got april data the
chart needs to reflect may 04 - april 05 and this needs to be done on 30
different charts. I manually change the data points for each of these graphs.

Is there an easier way to update these charts with a new data series without
manually going into each chart and changing the data source?

#2 05-25-2005, 12:06 PM

Take a look at this link on Dynamic Charts. It may get you where you want to
go:

http://www.peltiertech.com/Excel/Charts/Dynamics.html

"D richardson" wrote:

> I have data from jan 04 through present and each month new data is added to
> 30 different Areas
> I have a line chart for each Area (data on an excel spreadsheet) that needs
> to be updated for the twelve month period. (i.e. if i just got april data the
> chart needs to reflect may 04 - april 05 and this needs to be done on 30
> different charts. I manually change the data points for each of these graphs.
>
> Is there an easier way to update these charts with a new data series without
> manually going into each chart and changing the data source?

#3 05-25-2005, 02:06 PM

THANKS SO MUCH IT IS A LOT OF WORK TO REDO MY FORMAT...BUT IT WILL SAVE TIME
IN THE LONG RUN........THANKS AGAIN

"Barb R." wrote:

> Take a look at this link on Dynamic Charts. It may get you where you want to
> go:
>
> http://www.peltiertech.com/Excel/Charts/Dynamics.html
>
>
> "D richardson" wrote:
>
> > I have data from jan 04 through present and each month new data is added to
> > 30 different Areas
> > I have a line chart for each Area (data on an excel spreadsheet) that needs
> > to be updated for the twelve month period. (i.e. if i just got april data the
> > chart needs to reflect may 04 - april 05 and this needs to be done on 30
> > different charts. I manually change the data points for each of these graphs.
> >
> > Is there an easier way to update these charts with a new data series without
> > manually going into each chart and changing the data source?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)