LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 17
Default Ignore a Blank Data Series in the Legend

Hi,

I'm creating Pie Charts based on data from 10 data series fields. Some of
the data fields are blank, and so I've managed to create data labels that
only show on the Pie Chart if there is a value (otherwise the Chart was too
hard to read due to lots of blank labels).

However, if I show the Legend, the blank data series field still appear, so
I have say, 4 labels with the correct data series names but 6 which are
blank. Can I make the Legend ignore blank fields, and just show the 4 that
have values?

Thanks
 
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
How to change the series order in a LEGEND ONLY...not data Steve P[_2_] Charts and Charting in Excel 2 December 3rd 08 08:44 AM
Ignore blank checkbox-Data Validation Ted M H Excel Discussion (Misc queries) 0 May 22nd 08 02:33 AM
What is the point of Data-Validation-Ignore Blank? Vindaloo Excel Discussion (Misc queries) 2 June 15th 06 10:31 AM
Hide series names for unused data from chart legend Neil Goldwasser Charts and Charting in Excel 4 February 10th 06 07:13 PM
Hiding data series in legend RED Charts and Charting in Excel 1 February 8th 06 04:00 PM


All times are GMT +1. The time now is 12:52 AM.

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"