How do I change the legend text in Access 2002 chart?

[Jon]

I have a chart in a report which consists of a simple bar chart
displaying two series of information, and a logarithmic trendline for
each series. Each series is identified simply as "1" and "2". The
problem I have is the legend for this chart has "Log. (1)" and "Log.
(2)" as the identification text for the two trendlines. Is there some
way I can change that text to read "Trend 1" and "Trend 2"??

 

[Guest]

This usually depends on your Row Source query. You should be able to change
the column headings.

 

[Jon]

Umm.. let me clarify. The legend contains 4 lines of text:

1
2
Log. (1)
Log. (2)

The first two are the names of the source for the rows. That's exactly
how I want it. The problem is the last two items in the series... they
represent the names which are being given by Access automatically to
represent the trendlines for those two rows. THAT'S the item I want to
rename....

 

[Guest]

You may need to code this. I generally duplicate the chart in Excel. Turn on
the macro recorder and update the caption of the trend lines. Turn off the
recorder and then find the code in a module. Copy the code and paste it into
the On Format event of the report section containing the chart. Modify the
code to reference the chart object in your report.