Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
drop zero lines from charts
I have a automated chart I create every month. Sometimes there is no data for
that month. I'd like the chart to still show that month without the line dropping to zero. I have the data below the chart coming over as blank by formatting the cell to "number" and setting it at "0;-0;;". I was hoping that there is an easy way to have the line in the chart drop off also when there is no data to come over. Thanks in advance -- Baltimore Ravens |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
charts - 1 column and 2 lines | Charts and Charting in Excel | |||
3D charts and limit lines | Charts and Charting in Excel | |||
formatting lines in charts | Charts and Charting in Excel | |||
lines on bar charts | Charts and Charting in Excel | |||
Charts with many lines | Excel Discussion (Misc queries) |