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...
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...