Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-18-2023, 03:55 AM
SerenityNetworks SerenityNetworks is offline Pivot Chart, Horizontal Axis Formatting Windows 10 Pivot Chart, Horizontal Axis Formatting Office 2016
Advanced Beginner
Pivot Chart, Horizontal Axis Formatting
 
Join Date: May 2005
Location: Allen, Texas, USA
Posts: 37
SerenityNetworks
Question 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
Attached Images
File Type: jpg horizontal axis.jpg (135.7 KB, 7 views)
Reply With Quote
  #2  
Old 05-30-2023, 11:59 PM
chris-smith5 chris-smith5 is offline Pivot Chart, Horizontal Axis Formatting Windows 10 Pivot Chart, Horizontal Axis Formatting Office 2016
Novice
 
Join Date: Feb 2023
Posts: 3
chris-smith5 is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 06-02-2023, 07:13 AM
SerenityNetworks SerenityNetworks is offline Pivot Chart, Horizontal Axis Formatting Windows 10 Pivot Chart, Horizontal Axis Formatting Office 2016
Advanced Beginner
Pivot Chart, Horizontal Axis Formatting
 
Join Date: May 2005
Location: Allen, Texas, USA
Posts: 37
SerenityNetworks
Default

Thanks. but unless I'm missing something that is what I have done. When having two axis categories, only the first (top) rotates.
Attached Images
File Type: jpg chart axis issues.jpg (190.7 KB, 2 views)
Reply With Quote
Reply

Tags
format axis, pivot chart

Thread Tools
Display Modes


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
Pivot Chart, Horizontal Axis Formatting 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
Pivot Chart, Horizontal Axis Formatting 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft