ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Selective legend in Chart? (https://www.excelbanter.com/excel-discussion-misc-queries/159474-selective-legend-chart.html)

[email protected]

Selective legend in Chart?
 
Is there any way to have a selective legend in a chart?

That is, a legend that identifies some lines, but not others. In
particular, I do not want to identify the trendlines; just the actual
data curves.


Jon Peltier

Selective legend in Chart?
 
You can remove legend entries. Click once on the legend, then click once on
a legend entry you want to remove (not on the colored shape, just on the
label part), then press Delete.

To reinstate a legend entry, you need to delete the legend and add it back,
which creates a new legend with all entries.

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


wrote in message
oups.com...
Is there any way to have a selective legend in a chart?

That is, a legend that identifies some lines, but not others. In
particular, I do not want to identify the trendlines; just the actual
data curves.




[email protected]

Selective legend in Chart?
 
On Sep 24, 3:39 pm, "Jon Peltier"
wrote:
You can remove legend entries. Click once on the legend,
then click once on a legend entry you want to remove (not
on the colored shape, just on the label part), then press Delete.


Works great! Thanks. I had tried that before posting, to no avail.
My touchpad is "touchy". But when it did not work the first time, I
ass-u-me-d the feature did not work as I expected. Wrong!

To reinstate a legend entry, you need to delete the legend
and add it back, which creates a new legend with all entries.


Good to know. Thanks again.



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com