excel chart axis

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2013 Chart Axis Titles

Excel 2013 Chart Axis Titles

resolvedResolved · Low Priority · Version 2013

Jennifer has attended:
Excel Intermediate course
Excel Advanced course

Excel 2013 Chart Axis Titles

How can you do rotated titles for the Y Axis of a graph in Excel 2013?

RE: Excel 2013 Chart Axis Titles

Hi Jenny

Thanks for getting in touch and I hope you enjoyed your training today.

To restate your issue: you currently in Excel 2010 position your value axis title vertically above the axis, and you're trying to do this in Excel 2013.

Can you confirm you want it to look like the top-right chart in this link?

http://blogs-images.forbes.com/naomirobbins/files/2013/02/YaxisPositions.jpg

Because I cannot find an automated way to do this in any version of Excel. You can simply drag the Axis Title box to your desired location, but I can't find a menu option that will do this for you.

I do hope I've understood you correctly, please give me more information to help you fix your issue.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 11 Jun 2014: Automatically marked as resolved.


 

Excel tip:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips


Server loaded in 0.06 secs.