Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 80
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,489
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Customizing -2^2 Tim Walters Excel Discussion (Misc queries) 7 December 7th 09 01:13 AM
Customizing a dictionary Grant Excel Worksheet Functions 3 September 10th 09 01:22 PM
How to place a legend inside a legend 2Quick Excel Discussion (Misc queries) 0 April 21st 09 07:41 PM
Zero values not legend, Value grater then zero show data and legend Pamela[_3_] Excel Discussion (Misc queries) 1 January 28th 09 10:20 AM
Customizing Macros Haseeb Excel Discussion (Misc queries) 1 October 10th 07 10:36 AM


All times are GMT +1. The time now is 11:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"