RowSource for pivot chart

[fd1]

Hi All,
I created a pivot chart using Auto Form Pivot Chart. I'm trying to get to
the RowSource query behind my chart but can't seem to locate it. I need to change the
legend text. Any ideas?

Thanks

[MMcCarthy]

Hi All,
I created a pivot chart using Auto Form Pivot Chart. I'm trying to get to
the RowSource query behind my chart but can't seem to locate it. I need to change the
legend text. Any ideas?

Thanks

Not sure what you are trying to do exactly but have you tried switching to design view and going to the data property.

[fd1]

Not sure what you are trying to do exactly but have you tried switching to design view and going to the data property.

I did that, only thing I found is the Record Source which has the table name where data is coming from. When you create a chart using chart wizard, in the chart properties, there is a RowSource field that contains the query behind the chart. I need to change the text in my legend box and from what I learned, the only way to do it is to tweak the RowSource query for the chart.

[MMcCarthy]

Pivot Charts are not the same thing at all.

When you say you need to change the text in your legend box what exactly do you mean?

Have you looked at the Field List for the Pivot chart?

[fd1]

Pivot Charts are not the same thing at all.

When you say you need to change the text in your legend box what exactly do you mean?

Have you looked at the Field List for the Pivot chart?

The legend I have currently has text like 'Sum of...' and I would like to change it to something more descriptive.

[NeoPa]

The legend I have currently has text like 'Sum of...' and I would like to change it to something more descriptive.

I know very little about Pivot Charts, but usually in queries (in design view), if you want to assign a name to a field you add "Name: " to the beginning of the text in the Field (top one) box. Name would obviously be replaced by the name you want. An example might be :

Surname: SecondName