| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Lines in chart when no data is present
I have found the trick to prevent 0's from showing in a chart when the data
is blank: If(H2="",NA(),H2/F2) However, the chart line extrapolates from the previous data point to the next datapoint instead of showing a gap. I've looked at Tools-Options-Chart and the Active Chart - Plot Empty Cells as "Not Plotted (leave gaps)" is selected. The data is being charted on a secondary Y axis if this makes a difference. Please help. I need to have gaps. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create single chart with data from seperate worksheets | Charts and Charting in Excel | |||
| Can't get data from a web page to chart in excel. Any solutions? | Charts and Charting in Excel | |||
| Can't get data from a web page to chart in excel. Any solutions? | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
Threaded Mode
