| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How, on a line chart, to skip blank entry rather than plot as 0?
How, on a line chart, to skip blank entry rather than plot as 0?
|
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How, on a line chart, to skip blank entry rather than plot as 0?
Select the chart, go to tools, options, chart, and select interpolated. This
option should be avaliable for most chart types, though I've noticed its not for scatter. "JohnTerp" wrote: How, on a line chart, to skip blank entry rather than plot as 0? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a combo chart plot 4 variables? (3 bars,1 line) | Charts and Charting in Excel | |||
| Data showing incorrectly on line chart | Charts and Charting in Excel | |||
| Can I link timeline labels to a line chart? | Charts and Charting in Excel | |||
| Line chart for churn rates of many items over time | Charts and Charting in Excel | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
Linear Mode
