i intend to use vba to do the following.

This post, however, is not about the vba implementation details. It is more an attempt to understand
the capabilities of the scroll form control that I want to use to do the following.

below is the best way I can explain what I would like to do. any suggestions will be appreciated.
***********************************************************************

My goal is to start with the presentation of one chart with multiple scatter graphs depicted.
Each graph is a dependent variable. (Ie: Income, Expenses, Savings all as a function of time).

If a user left clicks on one of the above scatter graphs, I want to present a second chart
with multiple scatter graphs. The data for the scatter graphs in the second chart should provide
greater insight into one of the graphs in the first chart.(ie: if Income graph is left clicked in the
first chart, then a second chart is displayed with three scatter graphs depicted, one of “billed”,
one of “received” and the third of accounts receivable)

The user can then left clicks on any one of the scatter graphs of the second chart and a Third chart
should then be presented offering graphs offering greater insight into the just left clicked graph of the
second chart.

I would like the above process to continue as deeply as I need until I am displaying a chart with
the most basic data.

Th end result is actually a string or selected sequence of related charts. It is not a string of all possible charts.

So the question I am facing is how to present this information without making the viewer overwhelmed..

a way to achieve my quest is to overlay a window on the string of user created charts. that approach reveals
a finite set of adjacent charts at a location. Maybe the set could be three adjacent charts in the sequence and
the location might be the last three charts the user selected.

So in theory an excel spinner form control might define the number of charts displayed at any given moment and
an excel scroll bar form control might define where in the sequence of charts the viewer is looking.

Conceptually I am looking to scroll data but the data is an entire graph.

If I understand excel form controls correctly, the “link” in the spinner control needs to point to the number of graphs one desires
to see at any given time and the “link” in the scroll control needs to point to a cell whose content indicates where the user wants
to view his window of graphs.

What I would really like is for the scroll link to point to a chart.




So….my questions to you are:
(1) Can I actually use an existing scroll control to directly scroll charts.
(2) If not, How do I paste multiple charts into a display space? Can I use vba to extract its size and location and
Scale and redefine a location as needed? scrolling would then just be an increment of the y axis of the location. right?
(3) How do I maintain x axis alignment? If I define the range of the x axis, chart size, and location is that enough to align x Values?