avoid gap in chart in Excel
Q46. In Excel, how can I avoid a gap in a line chart for missing data?
For example, in a range of monthly sales data, if a particular month's sales figure is missing, the line chart is discontinuous as shown below.
To do it in Excel, here is the answer:
a) Right click on the chart area and then click "Select Data".
b) Click on "Hidden and Empty Cells"
c) Click on "Connect data points with line". Click OK -> OK.
d) The missing data point is ignored and the chart line is continuous.