Dynamic setting of x axis minimum value

[Knut Kvinnsland]

Hi,
I have a graph where dates are shown on the x axis. I would like the date range always to start on the date when I am updating the chart, e.g. sourced from a cell with formula =now().

Ideas, anyone...?

Kind regards,
Knut Kvinnsland

[Knut Kvinnsland]

Solved this one myself, I think. Using VBA to update the chart here.

Range("B3").Select
Application.CutCopyMode = False
Selection.Copy
ActiveSheet.ChartObjects("Diagram 5").Activate
ActiveChart.Axes(xlValue).Select
ActiveChart.Axes(xlValue).MinimumScale = ActiveCell
ActiveChart.Axes(xlValue).CrossesAt = ActiveCell