Dynamic Chart Title in Report

[MatthewR]

Re: https://www.accessforums.net/reports...ort-23126.html

Hey, folks. I'm trying to adjust my chart title through VBA, like in the above thread, and it's not working for me. Can you help me figure out what I'm doing wrong?

I have a form named StatRelationshipsYear, and a bar chart named RelationshipYearChart. And in the Format event of the Detail section, I put this code:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)


Me.RelationshipYearChart.ChartTitle.Text = "Test"
End Sub

I open the form, and I get nada. The code doesn't appear to have any effect. Any ideas?

Thanks for your help, people.

Matt

[June7]

Why use code? Why not just set title in chart design?

Report Format event only runs when report sent to printer or PrintPreview.

Thread title indicates a report but your narrative says form - which is it?

[MatthewR]

Thanks very much for the response. My mistake on the original post- it's a report, not a form.

I'm using code here because the chart is based on a parameter query. And I want the parameter to be part of the chart's title.

Is there any way to do that in Report View?

Also, with the current code, when I go to Print Preview mode, I get "Run-time error 1004: Unable to set the Text property of the ChartTitle Class."

So, it's not working for me in either view.

[June7]

Could use a textbox sitting on top of the chart. I've gone that route as well.

I don't know why the code fails. I've never tried to programmatically set the chart title, only the axis titles.

        With Me.gphDensity
        .Axes(xlValue, xlPrimary).HasTitle = True
        If Forms!DataSoilsAgg!Metric = True Then
            .Axes(xlValue, xlPrimary).AxisTitle.Text = "Max. Dry Density, Kg/cu.m"
        End If
        .Axes(xlCategory, xlPrimary).HasTitle = True
        If Forms!DataSoilsAgg!Metric = True Then
            .Axes(xlCategory, xlPrimary).AxisTitle.Text = "Percent Passing 4.75 mm Sieve"
        End If
        End With

[MatthewR]

Okay, thanks for the tip!

Initially, I didn't want to use text boxes because I wanted the user to be able to export the chart to Excel, and play with it.

Now, I'm realizing that you can't really export a chart to excel- you can only export data. True?

If so, I guess I might as well use text boxes, haha.

And I'll give the axis title strategy a try as well.