dynamic values in a chart

[riegerjm]

i am making a chart in which the cell range can change on-the-fly. for example, sometimes i may want to use cells B12:E13 and others i would use B12:G14 for the chart. what i want to know is if i can store that cell range in a separate cell and then somehow tell my chart to use that reference to select the range to plot?

 

[PaddyD]

see the dynamic chart tutorial here:

http://www.tushar-mehta.com

..post back if you need more.

paddy

 

[riegerjm]

I am trying to work with the Use a drop down box to select the starting value in 3) example in the Dynamic Charts tutorial... the only problem i am having is that when i select another option from my drop down list, my chart does not update automatically. i have to create a new chart using my "names" that i created to see the values change...

 

[riegerjm]

actually, i just downloaded the examples and found my answer. thank you so much for the help... i will use the tutorials again!!! they are great!

 

[PaddyD]

Glad you got it sorted!

 

[lakh4u2001]

Glad you got it sorted!

Can you please point me to the article on dynamic charts pls , iam looking to make one for my dashboard too.

The chart range might differ based on the visible cells.

 

[VoG]

This may help you Dynamic and Interactive Charts