geomo
Geotechnical
- May 4, 2001
- 15
I posted this in the VBA forum last week with no luck...
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
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