By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,719 Members | 1,875 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,719 IT Pros & Developers. It's quick & easy.

RowSource for pivot chart

P: 38
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
Oct 16 '07 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Oct 16 '07 #2

P: 38
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.
Oct 16 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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?
Oct 16 '07 #4

P: 38
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.
Oct 17 '07 #5

NeoPa
Expert Mod 15k+
P: 31,606
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 :
Expand|Select|Wrap|Line Numbers
  1. Surname: SecondName
Oct 21 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.