Scroll Bars - Form Tools On Worksheet For A Table And Chart

[warrenhamilton]

Hi

Ive added a scroll bar to my worksheet from the forms tools.

I want to have a table which is a fixed size and the scroll bar can b
used to move to columns across to view all data.

i.e. user views a fixed table of 5 columns but data is made up of 1
columns. The scroll bar will move the data.

I also want the same use for a chart.

Please Help....!

 

[Debra Dalgleish]

Stephen Bullen has a sample chart with scrolling on his web site.
Under 'Charting Examples', download FunChrt7.zip

http://www.bmsltd.co.uk/Excel/Default.htm

You could use the same technique to scroll through the table data.