Dynamic Chart with drop down list

**finlain** · 08-18-2010, 12:59 PM

Hey Andy
I am back ;( I have tried and tried and watched videos and I am not able to create the list and select that row of data to change my chart. You walked me through this 2 years ago and unfortunately I have not been able to come back to this until now. I plan on using this and I am hoping you can help me a 2nd time.
I have created the naed ranges, I have used the named ranges in the series and now the last two steps are completely frustrating me. Can you assist?

**finlain** · 08-18-2010, 01:00 PM

Hi Andy
This was originally my post

**Andy Pope** · 08-19-2010, 04:24 AM

I know it's your thread but lets start a new one.

In it explain your problem and what you are trying to achieve and post the example file again.

**ar2210** · 10-26-2011, 06:14 AM

I also have a similar problem.
I have created a table (pIvot table) and then craeted a normal chart based on values. I want a list box to change values based on the changing values in Pivot.
Can you please explain where to create the named ranges and why values 0, 1... etc so that I can modify my own chart with the correct formula.Thanks a lot.

**arthurbr** · 10-26-2011, 07:48 AM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

**ar2210** · 10-31-2011, 07:24 AM

My problem is similar to this post:
http://www.excelforum.com/excel-char...down-list.html

I have a pivot table in which I have data regarding revenue,profit,employees etc of different companies.I wish to have a chart for example compares the revenues of 2 companies A and X (A-1st companty data in first Pivot table) and (X-second company data in 2nd Pivot table.) This is a normal chart not a pivot chart.

Now I want to have a list that has a list of company names, as I change the name like from A to B in the dropdown list, the Data on chart should now show comparision of B vs X (B-1st pivot table, X from 2nd ).

Can you pls help.