I have data table with dates from AQ8 to BU8 and products in AP9-31.

In any one particular month the factory may only make on product, however in
other months it may make all 23. I would like to plot a graph of this data
that updates automatically - dynamic ranges.

As a result I have a graph that can move between one and 23 rows of data to
plot (series), each with its associated series name shown in the legend.

I have tried looking at Jon Peltiers website, C Pearson and several
questions on this discussion forum - no solution seems evident. Plotting the
data is no problem but getting the legend to update seems to be the catchy
part as even if I make it dynamic when I delete a series the legend will show
REF#.

What version of Excel are you using? In general when I want to plot
dynamically change rows of data I define the range as a table (2007) or list
(2003), then Excel automatically handles the changing number of rows.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"LiAD" wrote:

I have data table with dates from AQ8 to BU8 and products in AP9-31.

In any one particular month the factory may only make on product, however in
other months it may make all 23. I would like to plot a graph of this data
that updates automatically - dynamic ranges.

As a result I have a graph that can move between one and 23 rows of data to
plot (series), each with its associated series name shown in the legend.

I have tried looking at Jon Peltiers website, C Pearson and several
questions on this discussion forum - no solution seems evident. Plotting the
data is no problem but getting the legend to update seems to be the catchy
part as even if I make it dynamic when I delete a series the legend will show
REF#.

I'm in 2003.

I cant get dynamic items to work for the legend. For example if I start
with a full data table but then delete 6 of the 10 rows or whatever the plots
update but the legend will show REF#.

J.Peltier had a good suggestion of just hiding the rows or columns I dont
want to plot but in order for this to work and be usable I'd need to hide
part columns/rows. Do you know if this is possible?

If not i'd have monstrous sheet with my graph for Dec in col YY.

"Shane Devenshire" wrote:

What version of Excel are you using? In general when I want to plot
dynamically change rows of data I define the range as a table (2007) or list
(2003), then Excel automatically handles the changing number of rows.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"LiAD" wrote:

I have data table with dates from AQ8 to BU8 and products in AP9-31.

In any one particular month the factory may only make on product, however in
other months it may make all 23. I would like to plot a graph of this data
that updates automatically - dynamic ranges.

As a result I have a graph that can move between one and 23 rows of data to
plot (series), each with its associated series name shown in the legend.

I have tried looking at Jon Peltiers website, C Pearson and several
questions on this discussion forum - no solution seems evident. Plotting the
data is no problem but getting the legend to update seems to be the catchy
part as even if I make it dynamic when I delete a series the legend will show
REF#.

Instead of deleting the rows, hide them. By default, and Excel chart
does not plot data from hidden cells.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



LiAD wrote:
I'm in 2003.

I cant get dynamic items to work for the legend. For example if I start
with a full data table but then delete 6 of the 10 rows or whatever the plots
update but the legend will show REF#.

J.Peltier had a good suggestion of just hiding the rows or columns I dont
want to plot but in order for this to work and be usable I'd need to hide
part columns/rows. Do you know if this is possible?

If not i'd have monstrous sheet with my graph for Dec in col YY.

"Shane Devenshire" wrote:

What version of Excel are you using? In general when I want to plot
dynamically change rows of data I define the range as a table (2007) or list
(2003), then Excel automatically handles the changing number of rows.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"LiAD" wrote:

I have data table with dates from AQ8 to BU8 and products in AP9-31.

In any one particular month the factory may only make on product, however in
other months it may make all 23. I would like to plot a graph of this data
that updates automatically - dynamic ranges.

As a result I have a graph that can move between one and 23 rows of data to
plot (series), each with its associated series name shown in the legend.

I have tried looking at Jon Peltiers website, C Pearson and several
questions on this discussion forum - no solution seems evident. Plotting the
data is no problem but getting the legend to update seems to be the catchy
part as even if I make it dynamic when I delete a series the legend will show
REF#.