Dynamic chart using table, limiting rows with formula

[Cheeks1969]

Hi,
I have created a chart referencing data from a table. The first column in the table (A) is a formula that basically says if column B in the same row is not blank, then add a day from the date above. I paste a new month's data (via macro) in every so often and the date then appears and is used in the chart on the X axis.

However, since the formula goes way beyond the last data point the chart is also going out that far. So I have a huge white space to the right of my last data point in the chart.
Is there a way to leave the formula in and have the chart only use the rows with data?

Or must I ditch the formula and just drag the last cell to update the dates? I was hoping to have this mostly button driven since other people will be using it and there are 1000s of rows.
I hope that I've described this well enough for a reply.
Thanks for any input.

 

[ajboots]

Have you tried for xl2013:

right click on horizontal axis, select Format Axis. under Axis Options see the Bounds options. Try reducing the Maximum.