Change source data of graph with Combo Box

[gorgon777]

Hi there,

I have an 'in-cell dropdown' which looks up two values, Q1 and Q2
I have a range of data by month showing a specific number as below e.g


[TABLE="width: 500"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Count[/TD]
[/TR]
[TR]
[TD]2012-01[/TD]
[TD]120[/TD]
[/TR]
[TR]
[TD]2012-02[/TD]
[TD]190[/TD]
[/TR]
[TR]
[TD]2012-03[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]2012-04[/TD]
[TD]150[/TD]
[/TR]
[TR]
[TD]2013-05[/TD]
[TD]175[/TD]
[/TR]
</tbody>[/TABLE]

I have a Line graph using this entire table as the source data.
What I would like to do is only use part of the data based on what the dropdown cell specifies. For example, if it is set to "Q1", I would like just the 2012-01 and 2012-02 data to show in the graph. If its "Q2", I would like only 2013-03 and 2012-04 data to show in the graph.

How can I go about doing this?

 

[danzon]

This tutorial should get you there

Create a Dynamic Chart in Microsoft Excel | Chandoo.org - Learn Microsoft Excel Online

 

[gorgon777]

Thanks danzon, this does work great. However I am actually looking for a solution which uses one graph, and the source data range changes based on the combo box value. The reason I wish to do it this way is i have various other graphs on the sheet, so increasing cell size would mess things up a litt.e

 

[danzon]

OK, I see what you are after...

Here is how I would do it, the screenshot should explains in detail, let me know if you have questions after reviewing this

 

[gorgon777]

Again that is a great method, but I actually just want the months relevant to Q1 and Q2 to show, based on the dropdown selection. Below is a screenshot explaining the idea:

I appreciate your help, and hope this makes it a little more clearer