Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change the series order in a LEGEND ONLY...not data | Charts and Charting in Excel | |||
Ignore blank checkbox-Data Validation | Excel Discussion (Misc queries) | |||
What is the point of Data-Validation-Ignore Blank? | Excel Discussion (Misc queries) | |||
Hide series names for unused data from chart legend | Charts and Charting in Excel | |||
Hiding data series in legend | Charts and Charting in Excel |