Dynamic data selection for charts

S

sudheera

Hi,

I want to create a chart with dynamic data from a drop down. Like if i
select option 1 in the data validation drop down the chart should populate
with data from sheet 1. and if i select 2 then it should populate with sheet
2 data.

Please suggest a way to do the same

thanks
sudheera
 

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

Link a text box based on drop down box with four options MS Word 365 0
Filtered view of Visio Chart 0
Creating a Chart on form from selected data in query. 0
Drop down list control value in vba 2
How to make repeating drop-down lists? 2
One extra x axis item that wont go away - can anyone help? 3
Create a dynamic master file 1
MS Project Center-Autolink column fields 0

Top