How to change the Graph Type at Runtime using VBA in MS access

Here’s the given an article will guide you to know that “How to change the Graph type at run time” using VBA code in MS Access. This article explains through an example here:-

Firstly create a Table in the Database which contain 2 fields show below in fig :- 1.1.

How to change the Graph type at run time using VBA-Fig:-1.1

Fig:-1.1

Create a form with Graph and Radio Group. When the user click on the radio button then change the type of Graph. Eg:- If you click on column radio button then show the Graph in column. Show in fig:- 1.2.

How to change the Graph type at run time using VBA-Fig:-1.2

Fig:-1.2

If you click on the “line” radio button then Graph change in line format. Like this you change the Graph type like Column , Line , Pie , Area , Doughnut , Bar , Radar , Scatter. As shown in Fig:- 1.3.

How to change the Graph type at run time using VBA-Fig:-1.3

Fig:-1.3

Set the option value of radio button

Steps for set the option value of radio button

  • Select the radio button
  • Right click on selected radio button and click on properties option
  • After open the properties window go to Data -> Option value
  • Option values
    Column 51
    Line 4
    Pie 5
    Area 1
    Doughnut 80
    Bar 60
    Radar 82
    Radar 72


    ‘------------------- Code for On After Update event of the "optionGroupChart" -------------------

    Option Compare Database
    Private Sub optionGroupChart_AfterUpdate()
    [Graph0].Object.Application.Chart.ChartType = optionGroupChart
    End Sub


    DISCLAIMER

    It is advised that the information provided in the article should not be used for any kind formal or production programming purposes as content of the article may not be complete or well tested. Access Guru will not be responsible for any kind of damage (monetary, time, personal or any other type) which may take place because of the usage of the content in the article.