| 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? |
| 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) | |||
Threaded Mode
