Excel Embedded Chart Formatting

[geomo]

I'm trying to use an embedded chart in an Excel sheet where I want to switch between multiple data sets, and I only want to see one data set at a time. I can do this without a problem, but the size of the chart area needs to remain constant while I change the scale settings for the chart axes...the number of points in each data set varies, as does the range of values that will be displayed. So, I want to be able to tailor the chart axes scales to fit whatever data set is current, or else the data is hard to read on screen where I need it. I am a struggling to understand the process of using the Class Module and the ChartObjects, Charts, etc. rules that are required to do so. Any help is appreciated.

Keith