Forum Discussion

Tony2021's avatar
Tony2021
Iron Contributor
Sep 03, 2022
Solved

Modern Chart - adding Dynamic Chart Subtitle?

Hello Experts,    I have done some research on this topic and I have not been able to find a way to  add a dynamic chart title.  I have to manually copy and paste my text to the chart's subtitle fi...
access
Chart
  • isladogs's avatar
    isladogs
    Sep 03, 2022
    Yes - use DLookup
    Me.Chart0.ChartSubtitle = DLookup("FieldName", "Table/QueryName", "FilterCriteria")

    e.g.
    Me.Chart0.ChartSubtitle = DLookup("MyDateTime2", "t_Graphdata", "MyDataID = 4456")
isladogs's avatar
isladogs
MVP
Sep 03, 2022

Tony2021 

You just need to read the properties sheet to see what is available:
For example, if your chart is Chart0, then add code like this to the Form_Load event:

 

Me.Chart0.ChartTitle = "Your Chart Title Here"
Me.Chart0.HasSubtitle = True
Me.Chart0.ChartSubtitle = "Your Subtitle Here"

Tony2021's avatar
Tony2021
Iron Contributor
Sep 03, 2022

isladogs 

 

ah Ok I see.  

Could I refer to a query somehow?  

In the below, I manually type the Chart Subtitle and it comes from a query and I would like to somehow refer to the query to avoid manually typing making it more dynamic. 

 

  • isladogs's avatar
    isladogs
    MVP
    Sep 03, 2022
    Yes - use DLookup
    Me.Chart0.ChartSubtitle = DLookup("FieldName", "Table/QueryName", "FilterCriteria")

    e.g.
    Me.Chart0.ChartSubtitle = DLookup("MyDateTime2", "t_Graphdata", "MyDataID = 4456")
    • Tony2021's avatar
      Tony2021
      Iron Contributor
      Sep 04, 2022

      isladogs 

      Hi IslaDogs,

      I have a quick follow up when you have a sec.
      Do you happen to know how to break a long ChartSubtitle line into 2 lines?
      I thought by adding a continuation character would break it into 2 lines but that didnt seem to work as its still in 1 long line.

       

      Wondering if you happen to know of a workaround?

      • isladogs's avatar
        isladogs
        MVP
        Sep 04, 2022

        Tony2021 

        Yes - use a classic chart where each part of the chart can be manipulated
        I don't believe you can adjust the size or appearance of subtitles in a modern chart

    • Tony2021's avatar
      Tony2021
      Iron Contributor
      Sep 04, 2022
      Perfect. Exactly what I was looking for.

      thank you.
      • isladogs's avatar
        isladogs
        MVP
        Sep 04, 2022
        That's great. Glad I could help.
        Personally, I rarely use modern charts as I find them much more limited in terms of what you can do with them compared to the older 'classic' charts.

        You might be interested in the video of Crystal Long's presentation on Classic vs Modern charts to the AccessEurope User Group in May 2022.
        See https://www.youtube.com/watch?v=iTryE5nUSC8

Resources