A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Legends - Everyone stuck?



 
 
Thread Tools Display Modes
  #1  
Old September 11th, 2009, 11:15 AM posted to microsoft.public.excel.charting
LiAD
external usenet poster
 
Posts: 194
Default Legends - Everyone stuck?

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#.
  #2  
Old September 11th, 2009, 01:13 PM posted to microsoft.public.excel.charting
Shane Devenshire[_3_]
external usenet poster
 
Posts: 3,333
Default Legends - Everyone stuck?

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#.

  #3  
Old September 11th, 2009, 04:38 PM posted to microsoft.public.excel.charting
LiAD
external usenet poster
 
Posts: 194
Default Legends - Everyone stuck?

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#.

  #4  
Old September 12th, 2009, 06:19 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default Legends - Everyone stuck?

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#.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.