Issue with Excel chart x-axis

Question

The following sample workbook refers.  https://1drv.ms/x/s!AtbjuzRcDyZwyRpeoRnngdu8M4Tm?e=vha7Tn. 

(Note - this is made up data, just to demonstrate the following point)

By using the NA() resource, as used in the cells in column G, one can limit the data on the chart, avoiding the appearance of unnecessary zeros. 

But is it possible, also, to cause the x-axis to behave dynamically in a similar way, so that the x-axis is also dynamically limited to just those periods (e.g. months) that so far have data in them? 

I couldn't see how to do that. 

Thanks for any advice.

Answer 1

See https://www.dropbox.com/s/spwzzdu9vdq57wp/Donation-analysis.xlsx?dl=1

I created dynamic named ranges for the x-values and each of the four series, then edited the source data of the chart to use these named ranges. You can view the definition of the names by selecting Formulas > Name Manager.

Answer 2

Thanks very much. That fixed things perfectly!