LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 132
Default spinner control in chart sheet... please help!

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Save As from chart sheet maryj Charts and Charting in Excel 2 April 10th 06 04:26 PM
Dynamic column chart - copying from Sheet to Sheet. Marko Pinteric Excel Discussion (Misc queries) 1 April 10th 06 12:57 PM
How to control chart properties from worksheet Marko Pinteric Excel Discussion (Misc queries) 3 April 5th 06 12:38 PM
Change scales from reference cells value for a chart in a separate sheet ers Charts and Charting in Excel 4 April 2nd 06 07:00 PM
Excel2000: Weird chart behaviour Arvi Laanemets Excel Discussion (Misc queries) 2 September 6th 05 07:48 AM


All times are GMT +1. The time now is 10:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"