Chart that auto-rescales x-axis daily?

[Hambone70]

Hi!

I have a bar chart that contains daily data in rows. Each day, the new day's data automatically creates itself from many linked workbooks.

I would like the chart to display data up to and including today each day. Right now, I have to rescale the x-axis value every day to include today's date and its associated data.

Can this happen dynamically with a TODAY() command in either the data range or x-axis formatting?

Thanks in anticipation!

[BadlySpelledBuoy]

Have a look at the attached. There are some brief notes in there.

Is this something you can work with?

BSB

Dynamic Chart Example (BSB).xlsx

[Hambone70]

Perfect.

Thank you very much.