Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changed data lables in graph from 0% to blank or N/A
Hi,
I have a graph in Excel 2007 that is based on a pivot table. There is a numerator, Denominator and Rate. The rate is formated as a percentage on the graph. In my pivot table properties, I selected all error to show as N/A. There are a couple of values where the numerator and denominator are both 0. On my graph though, the data label shows as 0%. I want all 0% lables to be blank or show as N/A rather than 0%. Is there a way to do this? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
graph, data lables value, dont show zero values | Charts and Charting in Excel | |||
graph won't update when data is changed | Charts and Charting in Excel | |||
Do not show lack of data as a zero on graph lines, leave blank | Charts and Charting in Excel | |||
How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
REPOST: How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel |