Change chart as month changes

[adste89]

Hello,

I have a chart where I have to manually re-select the range for the data every month so that I can include the data for the month we are on.

So for example... A1:A4 is January, then when it gets to February I have to go to the chart > select Data and then change it to A5:A9 for February and so on.

Is there a way this can change automatically? Possibly with a named range or something? I have a cell that does =today() in "mmmm" format so it basically returns the month we are currently in...

So it would be great if the table could look at the cell that currently says "September" and know what data to display...

Any ideas or is this a bit too far?

[adste89]

cheeky bump

[adste89]

bumping this again - can anyone help?

[adste89]

Please can someone try and answer this?