Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ignoring null values in graph
I've built a data sheet to represent monthly result data that is appended to
each month. In the out-months a formula exists to prevent a DIV/0 error in the data sheet. Problem is, the out months graph with a zero value. How do I fix without having to update the chart range or formulas that calc the percentages each month? |
#2
|
|||
|
|||
Take a look at Jon Peltier's Dynamic Chart information
http://www.peltiertech.com/Excel/Cha...html#DynColCht Is this what you are looking for? "Kris B" <Kris wrote in message ... I've built a data sheet to represent monthly result data that is appended to each month. In the out-months a formula exists to prevent a DIV/0 error in the data sheet. Problem is, the out months graph with a zero value. How do I fix without having to update the chart range or formulas that calc the percentages each month? |
#3
|
|||
|
|||
If you don't want a dynamic chart per Barbara's suggestion, change your
formulas by replacing "" with NA(). What look like blanks ("") are really text, which are evaluated by Excel as zero. NA() produces the #N/A error in a sheet, which is certainly uglier than an empty cell but can be hidden with conditional formatting, and it also is skipped over by many common chart types. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Kris B wrote: I've built a data sheet to represent monthly result data that is appended to each month. In the out-months a formula exists to prevent a DIV/0 error in the data sheet. Problem is, the out months graph with a zero value. How do I fix without having to update the chart range or formulas that calc the percentages each month? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to ignore zero values when plotting a graph | Charts and Charting in Excel | |||
Unwanted zero values in a graph | Excel Discussion (Misc queries) | |||
Displaying values from zero on graph | Excel Discussion (Misc queries) | |||
Graph values in ascending order | Excel Discussion (Misc queries) | |||
Bar graph values keep changing | Charts and Charting in Excel |