Prev: Can not get Excel macros to format/save charts--help??? :(((((
Next: Incorporating Text Box in Excel Chart
From: KIOhio on 18 Mar 2010 17:45
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
From: teylyn on 20 Mar 2010 21:52

Hello Dan,

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

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

regards, teylyn



K
I
O
h
i
o
;
6
7
5
7
0
7

W
r
o
t
e
:


>
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

Teylyn -- 'teylyn.posterous.com' (http://teylyn.posterous.com)
------------------------------------------------------------------------
teylyn's Profile: 983
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=188792

http://www.thecodecage.com/forumz/chat.php

 | 
Pages: 1
Prev: Can not get Excel macros to format/save charts--help??? :(((((
Next: Incorporating Text Box in Excel Chart