ACC2000: How to Use Automation to Change a Graph's Type (210344)

MORE INFORMATION

1. Start Microsoft Access and open the sample database Northwind.mdb.
2. Create a new form based on the Ten Most Expensive Products query. On the Insert menu, click Chart, and then insert a new chart in the form.
3. In the Which Table or Query Would You Like to Use to Create Your Chart box, select the Ten Most Expensive Products query, and then click Next.
4. Select the two available fields and click Finish.
5. Set the embedded graph's Name property to MyGraph.
6. Add an option group to the form, and then add the following six option buttons to the option group:

      Name: Area
         OptionValue: 1
      Name: Bar
         OptionValue: 2
      Name: Column
         OptionValue: 3
      Name: 3D_Area
         OptionValue: -4098
      Name: 3D_Bar
         OptionValue: -4099
      Name: 3D_Column
         OptionValue: -4100
   					

7. Set the option group's Name property to Graph_Type and the option group's AfterUpdate property to the following event procedure:

   Private Sub Graph_Type_AfterUpdate()
      Me![MyGraph].Object.Application.Chart.Type = Int(Me![Graph_Type])
   End Sub
   					

8. View the form in Form view.
9. Click the various toggle buttons.
   
   Note that the chart changes to match your selection.