| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do you not include 0 value data on a graph?
I have a chart made that is formulated so that data fills in automatically
every month. I then have a graph attached that plots the data. My problem is that when there is no data for that month then the graph plots a continuous line that shows 0 after the real data. Is there anything that I can put in the formula so that if there is no value or 0 value it won't plot it on the graph? Hope this question makes sense! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to include variance data in the chart table but not on the gra | Charts and Charting in Excel | |||
| Expanding a data table to include an extra row | Excel Discussion (Misc queries) | |||
| How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
| Wrapping to include data from next row | Excel Worksheet Functions | |||
| How to include data on the same sheet some in database some not | Excel Worksheet Functions | |||
Threaded Mode
