How to use cell values to set a graphs x range

[baka_sleepy]

I have a bunch of graphs I’m using to track my workouts. I’d like to use the cell values for -1 month and +1 month to update the graphs for me so they cover a month either way from today, without having to manually adjust them myself. Whats the best way to set this up?

The +/- 1 month values are =EDATE(today,+/-1) and the cells have been formatted to date.

[Regina]

There exists no way to make the axis min and max value depend on a cell value. I would create two dummy data points and include them in the to be shown data ranges. Then the automatic scaling should work for you.

[Lupp]

Sorry, the large image is of a bit less use than of none at all.
A reduced small example file (.ods) would show what you actually have, and if the range for the horizontal axis is appropriately set.
= = =
To get a “gliding chart” you need helper columns. See attachment.
disask_132921_gliding_chart.ods (31.1 KB)
= = =
“@forum:”
Let me finally decide myself what I want to post, and if I want to make a “Suggested Solution” from what was drafted as a comment…

[Lupp]

Sorry. The example above contains a hint concerning the hiding of groups. Please ignore it.
I dindn’t know that charts dont accept data from hidden ranges - and I cannot find a sense in it.
If you want to get the helpers out of sight in the main sheet, you can move them to a helper sheet and adjust the references for the chart.
It’s clearly inconsistent that the chart accepts data from the helper sheet even if this sheet is hidden.
See new example:
disask_132921_gliding_chart_B.ods (44.4 KB)