Data Validation to range names for Chart Source Data

C

Candyman

I have 15 Named Ranges. I'd like to have a drop down above one chart to
select one of the names and the chart updates. How?
Please help
 
T

tpeter

It sounds like a pivot chart would give you the dynamic ability you are
looking for. If you build a Pivot table and chart you can drag the series
that you would like into the data range or have them on top to filter by.
Another option would be to use an advanced filter for your data. Using this
would also change the chart as you changed the filter.

Tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a chart from a table in word thats dynamic 0
Drop down list control value in vba 2
How to getting text labels to show up in scatter chart. 0
How to create a bubble chart with more than 2 variables. 0
One extra x axis item that wont go away - can anyone help? 3
Possible to Combine reports to's to a single box? 0
Creating a Chart on form from selected data in query. 0
Bar Chart with Data Elements 1

Top