Pivot Chart Axis Format?

J

joeshu26

Board Regular
Joined
Oct 30, 2013
Messages
136
Hello,

Does anyone know how to have your pivot table axis format change autumatically based on the field selection?

For example, if I have choose Net Income from my fields list the axis will be formatted as a number and if I alternatively choose CAGR from the fields list the axis will be formatted as a percentage.

Any help would be appreciated!
Thanks,
joeshu26
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
You must log in or register to reply here.

Similar threads

N
  • Question
How can I create a pivot chart with two line graphs?
Replies
1
Views
568
Jon Peltier
J
M
  • Question
PivotChart is not aligned with pivot table in terms of axis format
Replies
1
Views
358
Domenic
D
A
  • Question
Unable to Format Pivot Chart Axis Labels
Replies
1
Views
1K
Domenic
D
Y
  • Question
Label name doesn't appear in vertical axis of the chart
Replies
1
Views
243
yabi100
Y
Y
  • Question
Label name doesn't appear in vertical axis of the chart
Replies
4
Views
324
yabi100
Y

Forum statistics

Threads
1,202,958
Messages
6,052,785
Members
444,600
Latest member
margr

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top