Scrollbar to display graphs one at a time-

[sovvy]

I want to activate scrollbar to display graphs.
I have 200 columns and their 200 graphs.
data values are so close tht cant see 200 graphs and analyse them ..

I want to use scrollbar where on each move it will display 1 graph each at a time only. rest will be hidden for a while.
I ve set scrollbar value from 0 Min to 200Max with every move I ll get each graph to study.So i can compare it with ideal graph and conclude.

I am not getting how do I connect or link the each column(represent 1 graph) to each of scrollbar value from 0-200. On 0 value all graphs will be visible.
when I scroll with each stage from 1-200.. I will be able to view 1-200 graphs one by one.

I have wrote code individually for each column..which is not physibal
I want optimized code than writing 200 line code for all columns individually.

Reg
Sovvy

 

[Derek Brown]

Hello and welcome to The Board.
You need to visit Stephen Bullen's web page at:
http://www.oaltd.co.uk/Excel/Default.htm
where you can download an example workbook.
Look for the FunChrt7.zip link in the Charting Examples section.