Choosing right chart for a selected combination

[Jawahar]

Hi,
I have an query in excel regarding "Choosing right chart for a selected combination"

I have 3 individual parameters (A,B & C). Each parameter may have 2 or 3 sub parameters.
A - A1, A2 & A3
B - B1 & B2
C - C1, C2 & C3
For each non repetitive combinations between them, there will be a graph as an output.
How do I ? give my user, a choice to select his own combination and show corresponding output graph as result (in separate sheet).

Regards
Jawahar

 

[srinidhi]

Hi Jawahar,

If want to know which chart to choose. please go through this article

http://chandoo.org/wp/2010/04/19/chart-selection-process/

If you want dynamic charts, please upload the example excel