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

Working with 2 different scales/axes in PivotChart?

100+
P: 176
Hello All.

It's great to be in a place where people share their knowledge in a frendly way.


It's seem to me unlikely for PivotChart not to have a certain feature. I didn't find it, and looking through the net I couldn't find an explanation.


I have a table with a field of Cities being the Category Axis (X-Axis), a feild of AvgPayments being data Y-Axis with an automatic scale that takes into account the max. AvgPayments value, and a field of AvgDepts being another data Y-Axis (same type but with different, a much smaller max. value) with an automatic scale that takes into account the max. AvgDepts value.

As I build this type of chart, the 2 Y-Axes are built by the chart with the same automatic scale (that which takes into account the max value of both AvgPayments and AvgDepts). Now, if I chage the scale of one axis to a custom number the other scale changes too, not that if it wouldn't change, would help me, as I need 2 automatic different scales for 2 fields.

Anyone knows how to solve this?

Regards.
Nov 26 '06 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I'm afraid I don't use Pivot tables much.

I'm posting this to move this question back up the list.
Nov 27 '06 #2

P: 1
Anyone have a solution for this problem. I am having the exact same issue. Is there a way to get around this programmatically?
Jan 19 '07 #3

Post your reply

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