| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
dont show zero vaules in a chart
I have a chart that is tracking sales for the month, (by day) the chart has
Zero values due to an "IF" statment that has a false or the reference cell is not yet filled in resulting in a "zero value" the chart has a trend line that is tending based on all the remaining zero values . I have changed the Chart options to not display zeros, but this doesnt solve it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
| Show value in Data Table but not on live chart | Charts and Charting in Excel | |||
| Show goal in chart | Excel Discussion (Misc queries) | |||
| Fan charts | Charts and Charting in Excel | |||
| How can I show data under a Chart that I inserted in a worksheet? | Charts and Charting in Excel | |||
Threaded Mode
