Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
OTHER options for chart not plotting null ("") or zero values
I've read the above suggestions for a chart not plotting zeros or null
values. This worked....however, then I got errors because of other calculations (averages) that use these cells as references (and #NA just doesn't go over well when it's being used in another formula). Because of the many other formulas (in visual basic and in the exel file) that would need to be changed if i created an extra column, or did some of the other options I would REALLY prefer to not do any of those. Isn't there some way within the chart's options to exlude these values? Or is my best bet to go through the work of creating a seperate column that doesn't have the #NA in it? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
OTHER options for chart not plotting null ("") or zero values
How much does worksheet space cost? Nothing. And how much does your time and
effort cost to avoid using extra worksheet space? It's non trivial. Use a separate column, or a whole separate range, and link the ranges together. This saves time, effort, and frustration. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "superdanz" wrote in message ... I've read the above suggestions for a chart not plotting zeros or null values. This worked....however, then I got errors because of other calculations (averages) that use these cells as references (and #NA just doesn't go over well when it's being used in another formula). Because of the many other formulas (in visual basic and in the exel file) that would need to be changed if i created an extra column, or did some of the other options I would REALLY prefer to not do any of those. Isn't there some way within the chart's options to exlude these values? Or is my best bet to go through the work of creating a seperate column that doesn't have the #NA in it? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
OTHER options for chart not plotting null ("") or zero values
THanks...I was hoping you wouldn't say that this was my only option.
"Jon Peltier" wrote: How much does worksheet space cost? Nothing. And how much does your time and effort cost to avoid using extra worksheet space? It's non trivial. Use a separate column, or a whole separate range, and link the ranges together. This saves time, effort, and frustration. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "superdanz" wrote in message ... I've read the above suggestions for a chart not plotting zeros or null values. This worked....however, then I got errors because of other calculations (averages) that use these cells as references (and #NA just doesn't go over well when it's being used in another formula). Because of the many other formulas (in visual basic and in the exel file) that would need to be changed if i created an extra column, or did some of the other options I would REALLY prefer to not do any of those. Isn't there some way within the chart's options to exlude these values? Or is my best bet to go through the work of creating a seperate column that doesn't have the #NA in it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop chart from plotting null values as zeros in excel 20 | Charts and Charting in Excel | |||
How to create a scatter chart with 2 "X" values with common "Y"s | Charts and Charting in Excel | |||
Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
cells formatted to tick when text value "Y" if or null if "N" | Excel Discussion (Misc queries) | |||
"IF"- "THEN" type Formula based on Null value | Excel Worksheet Functions |