PC Review


Reply
Thread Tools Rate Thread

Category axis

 
 
Guest
Posts: n/a
 
      2nd Jun 2004
The text contents in my category axis (bar chart) are
about 5 words each. However, they all seem to look centred
(within their wrap) but NOT centred against each other in
a vertical line.
I would want them aligned on the left or right or if they
have to be centred at least in a verticle line to each
other.

Any ideas?
Deborah
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      2nd Jun 2004
Deborah -

I've been known to construct a fake axis using a helper series:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

You have a little more control over the data labels, including alignment.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

(E-Mail Removed) wrote:

> The text contents in my category axis (bar chart) are
> about 5 words each. However, they all seem to look centred
> (within their wrap) but NOT centred against each other in
> a vertical line.
> I would want them aligned on the left or right or if they
> have to be centred at least in a verticle line to each
> other.
>
> Any ideas?
> Deborah


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to display ranges in the category axis (X axis)? CaDai Microsoft Excel Charting 0 21st Sep 2009 03:10 AM
Chart templates treates value axis as a category axis FHW at EAD Microsoft Excel Charting 3 17th Dec 2008 03:19 AM
can I make the vertical axis the category axis in Excel line graph =?Utf-8?B?cG93ZXIx?= Microsoft Excel Charting 1 20th Mar 2006 08:45 PM
Adding data on Axis Major Gridlines next to Category Axis Collums =?Utf-8?B?amJsaXR0bGVqb2hu?= Microsoft Excel New Users 0 10th Jul 2005 12:17 PM
How do I make the Y axis in an excel chart the category axis? =?Utf-8?B?bWVnbmFkb29kbGU=?= Microsoft Excel Charting 2 29th Mar 2005 09:27 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:15 PM.