ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I limit labels in chart legend to only a portion of data? (https://www.excelbanter.com/charts-charting-excel/180508-how-do-i-limit-labels-chart-legend-only-portion-data.html)

Chart legend label limitation

How do I limit labels in chart legend to only a portion of data?
 
I am hoping to get a chart that includes four lines of data, but with only
two of the line labels for the data showing up in the chart legend. The two
lines that I want excluded are just straight bars that will include a text
box within the chart as their label, but I have run into problems with simply
slapping a line on the chart as it does not move around when we scale up or
down the two axes. Is there a way to get the legend to only show the label
identifiers with only the two sets of data that I want shown?

Thank you

Andy Pope

How do I limit labels in chart legend to only a portion of data?
 
Hi,

The legend displays an entry for each series in the chart.
You can however, once the legend is displayed, delete individual legend
entries.
http://www.andypope.info/charts/deletelegendentry.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Chart legend label limitation" <Chart legend label
wrote in message
...
I am hoping to get a chart that includes four lines of data, but with only
two of the line labels for the data showing up in the chart legend. The
two
lines that I want excluded are just straight bars that will include a text
box within the chart as their label, but I have run into problems with
simply
slapping a line on the chart as it does not move around when we scale up
or
down the two axes. Is there a way to get the legend to only show the
label
identifiers with only the two sets of data that I want shown?

Thank you




All times are GMT +1. The time now is 11:33 PM.

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