LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to scroll data in a chart?


Say I have a sheet with 10,000 rows of data. I could chart this data a
a whole but the data would be too bunched up for me to pick anythin
out, so say I want to only show 1000 rows worth on the chart, but hav
the ability to scroll forwards and backwards 1000 rows at a tim
without having to go into the source data dialog and manualy change th
specified range.

Could someone give me tips on how to go about doing this? I presume yo
could have some kind of script with a couple of buttons marked "forward
and "back" which would change the range the chart is using and refres
the display. Be advised I am very new to excel though do have some V
experience

--
Bubo10
-----------------------------------------------------------------------
Bubo101's Profile: http://www.excelforum.com/member.php...fo&userid=2456
View this thread: http://www.excelforum.com/showthread.php?threadid=38153

 
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
scroll/zoom xy chart [email protected] Charts and Charting in Excel 4 January 2nd 08 08:36 PM
SCROLL BAR FOR A 52 WEEK CHART Karine Charts and Charting in Excel 11 November 22nd 07 03:58 PM
how do i add a scroll bar to a line chart? jackrobyn1 Charts and Charting in Excel 3 May 26th 07 05:53 PM
dynamic chart with scroll bar tiw Excel Discussion (Misc queries) 0 April 21st 05 03:43 PM
scroll bar on chart disappears Bob Charts and Charting in Excel 3 April 17th 05 11:30 PM


All times are GMT +1. The time now is 11:00 PM.

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

About Us

"It's about Microsoft Excel"