Graph based on 2 drop down list

[pphg]

Hi Guys

Need your help to show in one graph the data based from the drop down list,

Attached excel file for reference. Appreciate your help guys. Thanks

[Kaper]

You shall build your graph based on named ranges. See attached file - 4 names defined. Two just pointing to the cells with your lists. Two other (for series and horizontal axis description) are based on OFFSET function. Check it out with Ctrl+F3.

[Julian86]

wow, that is really cool

[pphg]

Thanks Kaper, is it possible to show the graph as 12 months and just fill out the graph depending on the month selected? Thanks

[Kaper]

Hi,

The quickest way would be to add NA() at the end of series, but then you would receive slope to 0 from the last month (selected) to the one just folowing. (probably not what you would really like - see it on a pisture).

To have vertical "wall" after last month selected I'd suggest adding second "dummy" series wit empty values in it.
you can them click on the legend enrty, click on "dummy" in it and delete (it is improtant that it shall be two separate clicks - not doubleclick).
see the difference between upper (with extra legend entry) and lower charts.
This is how lower graph on the picture (and in the spreadsheet) is made.

Of course, as you are showing always 12 months - it is lo nolger needed to have a dynamic horisontal axis - categories are taken directly from worksheet DATA

[fideliscm]

Really so cool stuff..Keep it up.