Is it Possible for Excel to select Column Chart Data Source Dynamically??

[Kingkoopa]

Hey Guys,

Currently using windows 10 and Excel 2010.

Is there a way for excel to select the data source for Column Charts Dynamically?

Example :

	Australia	Vietnam	Indonesia	Mexico
Quarter 1	10	5	7	2
Variance 1	8	3	5	0
Quarter 2	11	4	8	6
Variance 2	7	0	4	2
Quarter 2 vs Quarter 1	-3	-5	-3	0

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

If I have a drop down list. That has Quarter 1, Quarter 2 and Summary.

1) If I chose Quarter 1 then graph would select Quarter 1 & Variance 1 data.
2) If I chose Quarter 2 then graph would select Quarter 2 & Variance 2 data.
3) If I chose Summary then graph would select Quarter 1 & Quarter 2 & Quarter 2 vs Quarter 1 data.

Currrently I can do 1) & 2) no issues by using vlookup to change the data output when different drop down list is selected. Problem arises when I try to include 3) as now I need to select 3 different rows of data.

Any idea guys, how I can incorporate them into a single dynamic graph? . Sorry if it sounds confusing.

Thank you

 

[JazzSP8]

If you're doing this how I think you are then you could add another data source that resolves to NA() unless your drop down box is equal to Q1 vs Q2?

=IF([DropDown]<>Q1vQ2,NA(),VLOOKUP(Etc. Etc.)

The #NA values would simply not be plotted on your Graph until the VLOOKUP populates?