Regarding the dynamic graphing: I have upto 6 series of data. I plot a
bar graph using the mean of each group, and use the calculated standard
error as the error. The way I am doing it, each bar/column is its own
series. I did it this way to make the legend show what each column
represents. My problem is that I don't always utilize all the series,
so my legend shows entries identifying some series that are not
actually being graphed, see picture.

I want it to automatically graph the columns that have data. I
understand that this may be possible I graph it as one series, but can
I still have each column associated with a name in the legend?

Nima


+-------------------------------------------------------------------+
|Filename: graph.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4225 |
+-------------------------------------------------------------------+

--
nima
------------------------------------------------------------------------
nima's Profile: http://www.excelforum.com/member.php...o&userid=30408
View this thread: http://www.excelforum.com/showthread...hreadid=500770

You should put different topics in different threads.

Make your chart with a single series, then double click the series, and on
the Options tab, check the Vary Colors by Point box. This format each point
individually, with its own legend entry. This only works in charts with one
series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"nima" wrote in message
...

Regarding the dynamic graphing: I have upto 6 series of data. I plot a
bar graph using the mean of each group, and use the calculated standard
error as the error. The way I am doing it, each bar/column is its own
series. I did it this way to make the legend show what each column
represents. My problem is that I don't always utilize all the series,
so my legend shows entries identifying some series that are not
actually being graphed, see picture.

I want it to automatically graph the columns that have data. I
understand that this may be possible I graph it as one series, but can
I still have each column associated with a name in the legend?

Nima


+-------------------------------------------------------------------+
|Filename: graph.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4225 |
+-------------------------------------------------------------------+

--
nima
------------------------------------------------------------------------
nima's Profile:
http://www.excelforum.com/member.php...o&userid=30408
View this thread: http://www.excelforum.com/showthread...hreadid=500770

I dont see how I can label each point with a cell reference anymore. I
varied the colors by points as you said (and changed overlap to 0 to
make it look better). I have 1 series with the 6 data points. I named
the series as a 6 cell range that corresponds to the 6 data points. In
the legend it labels the colors '1, 2, 3, 4, 5, 6'. I guess I still
dont understand how I get the names for each data point into the
legend.
<quoteThis only works in charts with one
series.</quote
If I follow your tutorial for making scientific annotated axes, then I
have to add another series, so wouldn't it remove the legend entries?

thank you for your patience.
Sorry for not posting in a new thread-i am new to this.


--
nima
------------------------------------------------------------------------
nima's Profile: http://www.excelforum.com/member.php...o&userid=30408
View this thread: http://www.excelforum.com/showthread...hreadid=500770

What shows up in the legend are the category labels. So if the labels were
A, B, C, etc, the legend would show these. If no category labels are
specified, Excel uses the counting numbers.

I realize that this technique is incompatible with adding a dummy series for
the axis, so I guess your new question is intricately linked to the older
one in the thread.

Rather than relying on the legend for a label, you could apply data labels
to the column series, so that each point has a label. Excel lets you use
category labels or values, and with the help of a third party Excel add-in,
you could use any cell contents you wish. Here are a couple good, free
labeling utilities:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com/ss

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"nima" wrote in message
...

I dont see how I can label each point with a cell reference anymore. I
varied the colors by points as you said (and changed overlap to 0 to
make it look better). I have 1 series with the 6 data points. I named
the series as a 6 cell range that corresponds to the 6 data points. In
the legend it labels the colors '1, 2, 3, 4, 5, 6'. I guess I still
dont understand how I get the names for each data point into the
legend.
<quoteThis only works in charts with one
series.</quote
If I follow your tutorial for making scientific annotated axes, then I
have to add another series, so wouldn't it remove the legend entries?

thank you for your patience.
Sorry for not posting in a new thread-i am new to this.


--
nima
------------------------------------------------------------------------
nima's Profile:
http://www.excelforum.com/member.php...o&userid=30408
View this thread: http://www.excelforum.com/showthread...hreadid=500770