Change MSGraph Chart Type
Posted on 2008-06-17
I have an Access 2003 app that displays MSGraph charts. The chart type as defined on the form is an XY Scatter.
I need to change it dynamically between an XY Scatter and a Bubble 3D. (I know I will have to manipulate the DataSheet that supports the chart.
If the chart is originally defined as a Bubble 3D, and I want to change it to an XY Scatter, then this code works:
GraphObj.ChartType = xlXYScatter
If, however, the chart is originally defined as an XY Scatter, and I want to change it to a 3D Bubble, then this code does NOT work:
GraphObj.ChartType = xlBubble3DEffect
In addition, if it starts as an XY Scatter, and I change it to a 3d Bubble, I cannot change it back. In fact, the chart type is permanently changed on the form.
How can I change it programmatically between an XY Scatter and a 3D Bubble?