Dynamic Chart with drop down list

Hi
I have a chart example that allows the user to click an item in the drop down list and a different chart displays.
They have example code using offset to select each item of data. Does anyone know how to get the list to select the correct data to chart?

I am attaching an exampleof some of the code being used. I have looked at several "Google" results and no luck

Thanks
Elaine
A2 CONCATENATE("Results for ",INDEX(A6:A11,A4))
Data OFFSET(Chart!$A$4,Chart!$A$4,1,1,4)
Metric_Name OFFSET(Chart!$A$4,Chart!$A$4,0,1,1)
Time Conversion 60*(MID(B12,6,2))+MID(B12,9,2)

I tried sending the working file yesterday and it was too large. I am attempting to make it smaller.
Thanks
Elaine

Hi Andy
The example that I gave you is not mine, I do not know how exactly to do this. I have the list box but the one I created is not working dynamically.
I'd try and send that file but I think it is too large.


Thanks
Elaine

Hi Andy
I did the first step and I know how to create and format the chart, but I am not sure of the third step here. How do I base a chart on named rages? I know it is easier than I am making it and I really appreciate your help!


Create named ranges for labels and data
Create and format chart
Base chart on named ranges
create listbox

Which step do you need help on?

Hi Andy
I am not getting it. If you can do one series, I'll be on my way. Here is the chart that I am actually working on.

Thanks a million!

Hi Andy
First thank you so much for your patience with this! I've done everything that you sent in the thread and the last item that is not working is the chart title. I saw in your note where you stated "Set the series formula to be,
=SERIES('650078.xls'!Metric_Name,'650078.xls'!LABELS,'650078.xls'!DATA,1)

The chart title is actually linked to the named range Metric_Name.

But I did not see that in your chart and yours works perfectly.

I am resending mine to see if you can see anything

Again thank you!

Elaine

Andy
Got it...thanks again for your help!

Elaine

Andy, I am trying to make two drop downs, graphing two lines on the same graph. I am using:
LABELS OFFSET(ProjChart!$A$2,0,1,1,7)
LABELS1 OFFSET(ProjChart!$A$6,0,1,1,7)
DATA OFFSET(LABELS,$A$2,0)
DATA1 OFFSET(LABELS1,$A$6,0)
Metric_Name OFFSET($A$2,$A$2,0,1,1)
Metric_Name1 OFFSET($A$6,$A$6,0,1,1)
Chart values: Metric_Name,DATA
Chart values1: Metric_Name1,DATA1
Where the first group of data is in cells A2:U5, with row 2 containing dates; the second group is in cells A6:U9, with row 6 containing the same dates.
I tried to set graph data as ProjChart!Metric_Name = ProjChart!DATA and ProjChart!Metric_Name1 = ProjChart!DATA1, but only the top set of data displays.

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?

Hi Andy
This was originally my post

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.

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.

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.

Please read my post - thx