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.

excel avoid gap in chart

To do it in Excel, here is the answer:

a) Right click on the chart area and then click "Select Data".

excel excel avoid gap in chart

b) Click on "Hidden and Empty Cells"

excel excel excel avoid gap in chart

c) Click on "Connect data points with line". Click OK -> OK.

excel excel excel excel avoid gap in chart

d) The missing data point is ignored and the chart line is continuous.

excel excel excel excel excel avoid gap in chart

 

You can find similar Excel Questions and Answer hereunder

1) How can I set Page orientation, Zoom % , Title Rows and footer using VBA?

2) How do I find the median salary of employees with the same skillset in my Organization?

3) how to combine the content of two or more cells in Excel

4) How can I add and link a Chart Title to a cell value?

5) How can I access previously auto saved versions of my current Excel workbook?

6) How can I add a legend to a chart using VBA?

7) Split string into multiple columns in Excel

8) How can I identify the cells that are dependent on a particular cell?

9) How can I get the day number of the year for a date - for example 5 for Jan 5, 33 for Feb 2?

10) How can I export a chart as a gif file?

11) Can I change the way that huge numbers are displayed in Y-Axis so that they do not take up chart space?

12) How can I dynamically add series to an existing chart using VBA?

13) How can I prevent edits on my worksheet by protecting it with a Password ?

14) How can I avoid updates to cell values during macro execution?

15) How can I calculate depreciation of assets using Excel?