Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I not plot zero values that result from a formula in Excel?
I have a data table with two rows.
One row calculates a percent complete value from the other row. The data is monthly. I am charting the results. The percent complete for a month is blank until I fill in the data for the month. The chart is plotting the blank percent complete as a zero. I set the chart options already to not plot blank cells, but I'm guessing since there is a formula in there it doesn't think that the cell is blank. What can I do? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I not plot zero values that result from a formula in Excel?
The problem is that "" looks like a blank, but Excel does not treat it as a
blank. Excel treats it like any other text, and assigns it a value of zero. Unfortunately Microsoft has not provided a function that returns a blank. The best we can do is use NA(), which places an #N/A error in the cell. Line and XY series do not plot a point if a cell contains #N/A. Your formula should look like =IF(<something,<value,NA()) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "tva11" wrote in message ... I have a data table with two rows. One row calculates a percent complete value from the other row. The data is monthly. I am charting the results. The percent complete for a month is blank until I fill in the data for the month. The chart is plotting the blank percent complete as a zero. I set the chart options already to not plot blank cells, but I'm guessing since there is a formula in there it doesn't think that the cell is blank. What can I do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you plot a graph with 3 axes e.g. xyz values on Excel? | Charts and Charting in Excel | |||
Need a formula to look up 2 values and return result from 3rd colu | Excel Worksheet Functions | |||
Formula Help - Perform a calculation only if the result falls between 2 values | Excel Discussion (Misc queries) | |||
Hide formula result values until all components are entered | Excel Discussion (Misc queries) | |||
BUG?: Excel scatter chart: will not plot x-values | Excel Discussion (Misc queries) |