Control Charting Data Range

[highflyer]

Hi there,

I have a data that looks like this:

Month      Jun-15  Jul-15  Aug-15  Sep-15
ValueA       1.0      1.2      1.4        1.2
ValueB       1.2      1.1      1.1        1.1
ValueC       1.2      1.0      1.4        1.1

And this data is presented in a lot of different graphs.

What I would like to be able to do is specify a start and end month, and have all the graphs update to show the requested date period.

I expect that in my charts in place if the column reference it would be replaced with some kind of variable, and I'd control that variable somewhere else, so all charts update like magic? Any suggestion on the simplest way to do this, or am I on the wrong track?

I've done some googling and my head is sore. I feel defeated.

Cheers,
HF