spinner control in chart sheet... please help!

[anna]

I wasn't sure where to post this question, so I have it posted under "Excel
Charts" as well. Here's the problem...

I have a worksheet with A LOT of data...
x Y Y1 Y2 Y3
data data data data data
.... .... ..... ..... .....

I have a chart sheet with all data plotted (xy scatter) and really need
something like a spinner button so that I can scroll and only plot a block of
my data at a time and have the chart update automatically with the contol.
Doesn't have to be a spinner button, but it was a guess on my part. I have
now bought 3 LARGE VBA for Excel books and am still unable to do seemingly
simple tasks I need. Could anyone take me step-by-step on how to set this up,
please?? Keep in mind I need it "dumbed down" to my basic beginner's level.
Thanks so much in advanced for any help you can give.
Anna

 

[Jim Cone]

Anna,
I have a very simple workbook example of a dynamic column chart
controlled by a dropdown list box.
You select a year from the list box and the chart reflects data for that year.
It might help you get started.
Email me and I will send it to you. Remove XXX from my email address.
--
Jim Cone
San Francisco, USA
(e-mail address removed)
http://www.realezsites.com/bus/primitivesoftware



"anna" <[email protected]>
wrote in message
I wasn't sure where to post this question, so I have it posted under "Excel
Charts" as well. Here's the problem...

I have a worksheet with A LOT of data...
x Y Y1 Y2 Y3
data data data data data
.... .... ..... ..... .....
I have a chart sheet with all data plotted (xy scatter) and really need
something like a spinner button so that I can scroll and only plot a block of
my data at a time and have the chart update automatically with the contol.
Doesn't have to be a spinner button, but it was a guess on my part. I have
now bought 3 LARGE VBA for Excel books and am still unable to do seemingly
simple tasks I need. Could anyone take me step-by-step on how to set this up,
please?? Keep in mind I need it "dumbed down" to my basic beginner's level.
Thanks so much in advanced for any help you can give.
Anna