software

Hi! Does anybody know a way to specify that a chart legend does not display
the name for a data series? Basically, I have 5 series plotted to allow for
up to 5 modes on my chart, and all the points use the same coloured lines to
demonstrate that they are all the same thing (modes). The legend wants to
display the names for all of them (quot;Mode 1quot;, quot;Mode 2quot;, etc...) but I would
prefer it to have just one entry (i.e. I would change quot;Mode 1quot; to simply
quot;Modequot;, to show that any green line is a mode, regardless of how many there
are - could range from 0 to 5 modes, depending on the data).

Is there a way (preferably avoiding VBA) to not show all the series names?
(I must have the legend visible to show the parts I do want seen). I thought
of just typing a space for the series name so that it comes up blank, but I
still get the 5 green line indicators, and I just need one.

If anybody has any ideas I would be very grateful for the help.
Neil

Neil -

Click the legend area once to select the entire legend area. Pause. Click a
single legend entry. Press Delete.

- Mike
www.mikemiddleton.com

quot;Neil Goldwasserquot; gt; wrote in
message ...
gt; Hi! Does anybody know a way to specify that a chart legend does not
gt; display
gt; the name for a data series? Basically, I have 5 series plotted to allow
gt; for
gt; up to 5 modes on my chart, and all the points use the same coloured lines
gt; to
gt; demonstrate that they are all the same thing (modes). The legend wants to
gt; display the names for all of them (quot;Mode 1quot;, quot;Mode 2quot;, etc...) but I would
gt; prefer it to have just one entry (i.e. I would change quot;Mode 1quot; to simply
gt; quot;Modequot;, to show that any green line is a mode, regardless of how many
gt; there
gt; are - could range from 0 to 5 modes, depending on the data).
gt;
gt; Is there a way (preferably avoiding VBA) to not show all the series names?
gt; (I must have the legend visible to show the parts I do want seen). I
gt; thought
gt; of just typing a space for the series name so that it comes up blank, but
gt; I
gt; still get the 5 green line indicators, and I just need one.
gt;
gt; If anybody has any ideas I would be very grateful for the help.
gt; Neil
Thanks Mike! Seems so simple now, but until you learn you can do that you'll
never know will you?

Thanks for your help, it was really getting on my nerves!
Neil

quot;Mike Middletonquot; wrote:

gt; Neil -
gt;
gt; Click the legend area once to select the entire legend area. Pause. Click a
gt; single legend entry. Press Delete.
gt;
gt; - Mike
gt; www.mikemiddleton.com
gt;
gt; quot;Neil Goldwasserquot; gt; wrote in
gt; message ...
gt; gt; Hi! Does anybody know a way to specify that a chart legend does not
gt; gt; display
gt; gt; the name for a data series? Basically, I have 5 series plotted to allow
gt; gt; for
gt; gt; up to 5 modes on my chart, and all the points use the same coloured lines
gt; gt; to
gt; gt; demonstrate that they are all the same thing (modes). The legend wants to
gt; gt; display the names for all of them (quot;Mode 1quot;, quot;Mode 2quot;, etc...) but I would
gt; gt; prefer it to have just one entry (i.e. I would change quot;Mode 1quot; to simply
gt; gt; quot;Modequot;, to show that any green line is a mode, regardless of how many
gt; gt; there
gt; gt; are - could range from 0 to 5 modes, depending on the data).
gt; gt;
gt; gt; Is there a way (preferably avoiding VBA) to not show all the series names?
gt; gt; (I must have the legend visible to show the parts I do want seen). I
gt; gt; thought
gt; gt; of just typing a space for the series name so that it comes up blank, but
gt; gt; I
gt; gt; still get the 5 green line indicators, and I just need one.
gt; gt;
gt; gt; If anybody has any ideas I would be very grateful for the help.
gt; gt; Neil
gt;
gt;
gt;

Hi again Mike! Sorry, I forgot to ask something. Let's say that having
deleted it, it later becomes apparent that I need the series name back in the
legend again - how would I do this please?

Again, many thanks for your help, Neil
quot;Neil Goldwasserquot; wrote:

gt; Thanks Mike! Seems so simple now, but until you learn you can do that you'll
gt; never know will you?
gt;
gt; Thanks for your help, it was really getting on my nerves!
gt; Neil
gt;
gt;
gt;
gt;
gt; quot;Mike Middletonquot; wrote:
gt;
gt; gt; Neil -
gt; gt;
gt; gt; Click the legend area once to select the entire legend area. Pause. Click a
gt; gt; single legend entry. Press Delete.
gt; gt;
gt; gt; - Mike
gt; gt; www.mikemiddleton.com
gt; gt;
gt; gt; quot;Neil Goldwasserquot; gt; wrote in
gt; gt; message ...
gt; gt; gt; Hi! Does anybody know a way to specify that a chart legend does not
gt; gt; gt; display
gt; gt; gt; the name for a data series? Basically, I have 5 series plotted to allow
gt; gt; gt; for
gt; gt; gt; up to 5 modes on my chart, and all the points use the same coloured lines
gt; gt; gt; to
gt; gt; gt; demonstrate that they are all the same thing (modes). The legend wants to
gt; gt; gt; display the names for all of them (quot;Mode 1quot;, quot;Mode 2quot;, etc...) but I would
gt; gt; gt; prefer it to have just one entry (i.e. I would change quot;Mode 1quot; to simply
gt; gt; gt; quot;Modequot;, to show that any green line is a mode, regardless of how many
gt; gt; gt; there
gt; gt; gt; are - could range from 0 to 5 modes, depending on the data).
gt; gt; gt;
gt; gt; gt; Is there a way (preferably avoiding VBA) to not show all the series names?
gt; gt; gt; (I must have the legend visible to show the parts I do want seen). I
gt; gt; gt; thought
gt; gt; gt; of just typing a space for the series name so that it comes up blank, but
gt; gt; gt; I
gt; gt; gt; still get the 5 green line indicators, and I just need one.
gt; gt; gt;
gt; gt; gt; If anybody has any ideas I would be very grateful for the help.
gt; gt; gt; Neil
gt; gt;
gt; gt;
gt; gt;

Neil -

It's not so easy, but then not too hard. Delete the legend, and using the
button on the chart toolbar or using Chart menu gt; Chart Options gt; Legend
tab, add it back.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;Neil Goldwasserquot; gt; wrote in
message ...
gt; Hi again Mike! Sorry, I forgot to ask something. Let's say that having
gt; deleted it, it later becomes apparent that I need the series name back in
gt; the
gt; legend again - how would I do this please?
gt;
gt; Again, many thanks for your help, Neil
gt;
gt;
gt;
gt; quot;Neil Goldwasserquot; wrote:
gt;
gt;gt; Thanks Mike! Seems so simple now, but until you learn you can do that
gt;gt; you'll
gt;gt; never know will you?
gt;gt;
gt;gt; Thanks for your help, it was really getting on my nerves!
gt;gt; Neil
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Mike Middletonquot; wrote:
gt;gt;
gt;gt; gt; Neil -
gt;gt; gt;
gt;gt; gt; Click the legend area once to select the entire legend area. Pause.
gt;gt; gt; Click a
gt;gt; gt; single legend entry. Press Delete.
gt;gt; gt;
gt;gt; gt; - Mike
gt;gt; gt; www.mikemiddleton.com
gt;gt; gt;
gt;gt; gt; quot;Neil Goldwasserquot; gt; wrote in
gt;gt; gt; message ...
gt;gt; gt; gt; Hi! Does anybody know a way to specify that a chart legend does not
gt;gt; gt; gt; display
gt;gt; gt; gt; the name for a data series? Basically, I have 5 series plotted to
gt;gt; gt; gt; allow
gt;gt; gt; gt; for
gt;gt; gt; gt; up to 5 modes on my chart, and all the points use the same coloured
gt;gt; gt; gt; lines
gt;gt; gt; gt; to
gt;gt; gt; gt; demonstrate that they are all the same thing (modes). The legend
gt;gt; gt; gt; wants to
gt;gt; gt; gt; display the names for all of them (quot;Mode 1quot;, quot;Mode 2quot;, etc...) but I
gt;gt; gt; gt; would
gt;gt; gt; gt; prefer it to have just one entry (i.e. I would change quot;Mode 1quot; to
gt;gt; gt; gt; simply
gt;gt; gt; gt; quot;Modequot;, to show that any green line is a mode, regardless of how many
gt;gt; gt; gt; there
gt;gt; gt; gt; are - could range from 0 to 5 modes, depending on the data).
gt;gt; gt; gt;
gt;gt; gt; gt; Is there a way (preferably avoiding VBA) to not show all the series
gt;gt; gt; gt; names?
gt;gt; gt; gt; (I must have the legend visible to show the parts I do want seen). I
gt;gt; gt; gt; thought
gt;gt; gt; gt; of just typing a space for the series name so that it comes up blank,
gt;gt; gt; gt; but
gt;gt; gt; gt; I
gt;gt; gt; gt; still get the 5 green line indicators, and I just need one.
gt;gt; gt; gt;
gt;gt; gt; gt; If anybody has any ideas I would be very grateful for the help.
gt;gt; gt; gt; Neil
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;