Plotting with missing data


The top data gives the chart on the left - the missing August data shows as a gap. When an empty cell is filled with =NA(), Excel interpolates the missing data, joining adjacent data points

Alternatively, you may select the chart and use Tool|Options and open the Chart tab to tell Excel how to handle missing data see diagram below

Return to Excel Tips & Tricks