 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / May 2008Justifying 2-line category names in bar charts
When a category name wraps on to 2 lines, Excel centers the second line under the first. I'd like to figure out a way to right justify the second line. I'd also like to figure out a way to set that as a default. Hi, You do not have much control over the axis labels and their appearance. If you want full control you will need to use textboxes. This page has code to help with construction and alignment. http://www.andypope.info/vba/Axislabel_textboxes.htm Cheers Andy > When a category name wraps on to 2 lines, Excel centers the second line under > the first. I'd like to figure out a way to right justify the second line. > I'd also like to figure out a way to set that as a default.  SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info Thanks Andy. I'll try this out when I get to the office on Monday. Camille > Hi, > [quoted text clipped - 10 lines] > > the first. I'd like to figure out a way to right justify the second line. > > I'd also like to figure out a way to set that as a default.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.