View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Stormy Stormy is offline
external usenet poster
Posts: 17
Default Ignore a Blank Data Series in the Legend


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?