Y Axis data source changes based on the Named range listed in Dropdown

**aravindhan_31** · 04-29-2009, 02:40 PM

Hi,

I am facing a problem in excel charting. The chart is created based on the datas of Colum Q&R ColQ is X axis. my chart is created based on the data of Details "A" that is col R ( Y Axis) I have a validation list in cell N5, A,B,C,D,E etc

What I would require is , if I select B, then the chart has to be updated based on ColS, If C is selected then Y axix data should be updated as ColT and so on.
I have attached my excel file for your reference.

Thanks in advance for your help
Arvind

**aravindhan_31** · 04-29-2009, 02:52 PM

Hi
The cross post is here
http://www.mrexcel.com/forum/newthre...ostthread&f=10

**Chance2** · 04-29-2009, 03:37 PM

You need to make a named range for the Series1.
See attached....

**aravindhan_31** · 04-30-2009, 01:02 AM

Hi,

Perfect thanks a lot for your help.

Arvind

**Ahousman** · 11-08-2012, 05:36 PM

I have a similar set up, but I'd like the minimum on the y axis to be diffferent for each detail A,B,C....I notice the maximum value changes is it possible to change the minimum for each detail?

Thanks,
Amy

**arlu1201** · 11-09-2012, 12:43 AM

Ahousman,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.