#1
|
|||
|
|||
Pivot Chart, Horizontal Axis Formatting
In a pivot chart, I am using two values on the horizontal axis (axis categories). The Month/Year is sorted by Class Count (ascending), but when I expand both axis categories (to show both the Class Session and Month/Year) then the formatting of the Month/Year changes to horizontal and will not fit in the space allotted. I have not been able to figure out how to have both the Class Session and Month/Year to rotate 270 degrees. Only the first of the two values will rotate. The other will be horizontal.
How do I show both values on the horizontal axis and get both to format rotated 270 degrees? Thanks in advance, Andrew |
#2
|
|||
|
|||
Hi,
You can follow these steps: -Select the pivot chart. -Right-click on the horizontal axis (axis categories) and choose "Format Axis" from the context menu. -In the Format Axis pane, under the "Axis Options" tab, find the "Text Options" section. -Expand the "Text Options" section and click on the "Text Fill & Outline" dropdown arrow. -Choose the desired text fill color for the axis labels. -Click on the "Text Effects" button (represented by a capital 'A' icon) next to the "Text Fill & Outline" dropdown. -In the "Text Effects" dialog box, go to the "Text Box" tab. -Under the "Text Box Options" section, find the "Text Direction" dropdown and choose "Rotate all text 270°". -Click "Close" to apply the changes and close the dialog box. -Close the Format Axis pane. Best Regards. |
#3
|
|||
|
|||
Thanks. but unless I'm missing something that is what I have done. When having two axis categories, only the first (top) rotates.
|
Tags |
format axis, pivot chart |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to format horizontal date axis in chart? | Sunny Rio | Word | 5 | 12-24-2022 10:05 PM |
Animate Horizontal Axis Title of chart with its values | Marcia | PowerPoint | 3 | 02-22-2022 07:46 AM |
my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. | jalea148 | Excel | 3 | 01-06-2017 09:04 AM |
Select which labels to display on horizontal axis on line chart | Jack H | Excel | 5 | 01-13-2016 10:05 AM |
Secondry Axis overlapping in bar chart dual axis in Powerpoint 2010 | sharath_ms | PowerPoint | 0 | 07-08-2013 10:06 PM |