Change Series Name in Legend in Chart Report using VBA

[Kirsti]

Hi there,



I asked this question in the report forum, but wasn't able to solve my issue.

I know that it must be possible to change the series name in a chart using VBA, but am not at all experienced with writing it myself.

Is anyone able to help with some code to enable me to do this?

Any help much apreciated,

Kirsti

[June7]

No, don't think can do with code. The series name comes from the chart's RowSource data. If you want something else will have create an alias field with an expression in query and use that field in the chart RowSource.

[Kirsti]

Thanks June,

Even if I do what you suggest though I'm not going to be able to get rid of the annoying "SumOf", "AvgOf" in the chart though right? So the only thing to do is calculate everything in the query?

[June7]

You can use whatever name you want in place of the 'SumOf', 'AvgOf' in the query design. You aren't already doing calcs in the query? What type of chart and how is the data summarized? Sounds like you doing something I am not familiar with. If you want to provide project for analysis, I will look at.

[Kirsti]

Thanks June. I usually do my calcs in the query, but sometimes I have a number that I want to total and average in the chart, and it would be easier to do it within the report if there was some way to change the series name. But as there doesn't appear to be any quick fix, I've done it in the query.

Thanks again for your help.