| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Graphs help
Hi,
I noticed that when there are cells with NA, it shows on the graph as 0. Is there a way to fix this instead? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Graphs help
Just right click on that cell which has a value NA and click Clear Contents.
The chart will not display zero value. Challa Prabhu "Aloysicus" wrote: Hi, I noticed that when there are cells with NA, it shows on the graph as 0. Is there a way to fix this instead? -- Aloysicus |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Graphs help
Don't put in NA as a text string, use #N/A or =NA() instead.
-- David Biddulph "Aloysicus" wrote in message ... Hi, I noticed that when there are cells with NA, it shows on the graph as 0. Is there a way to fix this instead? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel graphs won't update | Charts and Charting in Excel | |||
| Pasting Graphs - making me crazy! | Excel Discussion (Misc queries) | |||
| HYPERLINK GRAPHS | Charts and Charting in Excel | |||
| Are there better GRAPHS within EXCEL or Add-on graphs? | Charts and Charting in Excel | |||
| Copying Charts and graphs to another worksheet with formulas | Excel Worksheet Functions | |||
Linear Mode
