ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Customizing the Legend (https://www.excelbanter.com/excel-programming/272005-customizing-legend.html)

Phil Hageman

Customizing the Legend
 
I have five series on a chart.
Target, UCL, Data, LCL, OpZero

Is there a way to remove some of them (UCL, Data, LCL)
from the legend?

Thanks, Phil

Andy Pope

Customizing the Legend
 
Hi Phil,

To remove an item from the legend and leave the data displayed in the chart.
Click legend once
Cick legend entry (both text and legend marker) once
then delete.

If you click the legend marker and delete you will remove the data as well.

Phil Hageman wrote:
I have five series on a chart.
Target, UCL, Data, LCL, OpZero

Is there a way to remove some of them (UCL, Data, LCL)
from the legend?

Thanks, Phil


--

Cheers
Andy

http://www.andypope.info



All times are GMT +1. The time now is 09:05 PM.

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