LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Neil Goldwasser
 
Posts: n/a
Default Hide series names for unused data from chart legend

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 ("Mode 1", "Mode 2", etc...) but I would
prefer it to have just one entry (i.e. I would change "Mode 1" to simply
"Mode", 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
 
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
Can i use the IF function in a chart to choose its data series? Edd UK Charts and Charting in Excel 2 April 2nd 23 07:57 PM
I need more general XY point to point plotting than XY scatter in spazminator Charts and Charting in Excel 12 December 19th 05 05:00 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


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

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

About Us

"It's about Microsoft Excel"