Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2012

    Unanswered: Dynamic chart text - titles


    I have a chart on a form which displays data selected by the user, as a result the y axis and chart title need to change in response to the variable selected by the user.

    I can set the title to equal some text using:

    Me.JGGraph.ChartTitle.Text = "My New Title"

    but i cannot get it to use the text displayed in my Combo Box ([ComboParameter]) which is what is selected by the user.

    Is there anyway to do this for the title and the Y axis(2)?


  2. #2
    Join Date
    Jan 2009
    Kerala, India
    You can find a program in the following link, where the given code can be modified to include parameters to pass values for titles or Y-axis titles and assign them dynamically:

    Working with Chart-Object in VBA (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts