Combine Rolling Chart and Dynamic Chart with Combobox.

[ccsher]

Good Morning,

I am attempting to combine a Dynamic rolling chart with aCombo box to select different data streams.

For example:

The data sheet has sales volumes for 3 customers frompast 36 months

I have been able to produce a rolling chart using OFFSETformula and named ranges which allows me to display anywhere between previous 1- 36 months.

I can also produce a separate dynamic chart which allows me to display each customer by making a selection from aCombo box

What I struggling is how to combine the two. (i.e I wouldlike to be able to display last 12 months volumes of Customer B but haveflexibility to then change to Customer A.)

I thought of perhaps combining the named ranges /formulas but I cannot seem to achieve the desired outcome

can anyone offer any advice?.

Thanks