| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I hide zero values (and their titles) in a pie chart in exc
|
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I hide zero values (and their titles) in a pie chart in exc
A zero value will have a pie wedge of angle 0 so is invisible
To remove label (not title) click on label once, pause, click again. Now only one label is visible; tap the DELETE key If the value changes to a non-zero value, restore the label by right clicking chart area; use Chart Options; one Data Labels tab check the desired label item(s) For an automated method you will need VBA - post your question to the Excel programming newsgroup best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Kat" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart Titles not showing in excel chart | Excel Discussion (Misc queries) | |||
| Chart Titles not showing in excel chart Window | Excel Discussion (Misc queries) | |||
| Stack Bar chart Titles | Charts and Charting in Excel | |||
| how to hide zero values on line chart | Charts and Charting in Excel | |||
| Centering Axis and Chart Titles on chart | Excel Discussion (Misc queries) | |||
Linear Mode
