SOLVED

Modern Chart - adding Dynamic Chart Subtitle?

Super Contributor

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 field in the chart's properties.  

 

Is there a trick to adding a dynamic subtitle?  

 

 

7 Replies

@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"

@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. 

Tony2021_0-1662245342715.png

 

best response confirmed by isladogs (MVP)
Solution
Yes - use DLookup
Me.Chart0.ChartSubtitle = DLookup("FieldName", "Table/QueryName", "FilterCriteria")

e.g.
Me.Chart0.ChartSubtitle = DLookup("MyDateTime2", "t_Graphdata", "MyDataID = 4456")
Perfect. Exactly what I was looking for.

thank you.
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

@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?

@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