ReAim chart data range

[KIOhio]

instead of the tedious retyping the cell references to change the data range
for a chart, is there a way to do it with sliders? If so, how?

thanks,

Dan

 

[teylyn]

Hello Dan,

use dynamic range names for your data series and refer to these rang
names. Then you can use sliders or other tools to populate the ranges.

See some good tutorials on Jon Peltier's site: 'Dynamic and Interactiv
Charts' (http://peltiertech.com/Excel/Charts/Dynamics.html)

regards, teylyn


instead of the tedious retyping the cell references to change the dat
range