| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Justifying 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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Justifying 2-line category names in bar charts
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 Camille wrote: 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. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Justifying 2-line category names in bar charts
Thanks Andy. I'll try this out when I get to the office on Monday. Camille "Andy Pope" wrote: 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 Camille wrote: 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. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i apply labels (or category names) to columns? | Excel Worksheet Functions | |||
| How do I insert a blank line when category changes | Excel Discussion (Misc queries) | |||
| Category names become shortened | Charts and Charting in Excel | |||
| Problems with updating category names in pivot tables | Excel Discussion (Misc queries) | |||
| subrow names must appear in consolidating by category as tab name | Excel Worksheet Functions | |||
Linear Mode
