| 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 | |||
![Chuck W[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
