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

Month	Count
2012-01	120
2012-02	190
2012-03	200
2012-04	150
2013-05	175

<tbody>
</tbody>

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