Forum Discussion
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...
- Yes - use DLookup
Me.Chart0.ChartSubtitle = DLookup("FieldName", "Table/QueryName", "FilterCriteria")
e.g.
Me.Chart0.ChartSubtitle = DLookup("MyDateTime2", "t_Graphdata", "MyDataID = 4456")
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.
Yes - use DLookup
Me.Chart0.ChartSubtitle = DLookup("FieldName", "Table/QueryName", "FilterCriteria")
e.g.
Me.Chart0.ChartSubtitle = DLookup("MyDateTime2", "t_Graphdata", "MyDataID = 4456")
Me.Chart0.ChartSubtitle = DLookup("FieldName", "Table/QueryName", "FilterCriteria")
e.g.
Me.Chart0.ChartSubtitle = DLookup("MyDateTime2", "t_Graphdata", "MyDataID = 4456")
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?
- 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