Set "Chart Title"

[Guest]

I have controls to open up different charts. Currently, I have 3 different
charts for 3 different option based off of the same data but filtered
differently. I would like to use one chart but I don't know how to
automatically change the title depending on the event.

Any suggestions?

TIA

 

[fredg]

I have controls to open up different charts. Currently, I have 3 different
charts for 3 different option based off of the same data but filtered
differently. I would like to use one chart but I don't know how to
automatically change the title depending on the event.

Any suggestions?

TIA

..

You can use code to change the ChartTitle.Text property.
For example, the following code, placed in a report section's Format
event will display a variable location and date as chart title:

Me!OLEUnbound0.ChartTitle.Text = Forms!frmDate!List12 & " " &
Format(Forms!frmDate!Text0, "mmmm yyyy")
Me!OLEUnbound0.Refresh

Place the code in whatever section the chart is displayed in.
OLEUnbound0 is the name of the chart control in the report.
frmDate is the name of the form from which the user can select the
location (List12) and date (Text0) to create the chart on.