LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 21
Default How to colntrol location of category X axis labels on a bar chart?

How to colntrol location of category X axis labels on a bar chart?

usually data have only positive values, category X axis labels are in the
left side of vertical axis (see labelsOK.jpg). When values are all negative,
labels are crossing bars (see labels03.jpg). Basically labels are always to
the left from vertical axis (see labels01.jpg and labels02.jpg) which is not
always visually appealing. Is there a way to have labels for case when data
are all negative, located to the right from the axis and axis itself indented
from chart border, so it will be a mirror image of labelsOK.jpg (see
labelsOKmirror.jpg, but of course text and digits should not be mirrored!).

I do not see how to upload images, would happy to email them to whoever will
be kind enough to ask )
for now I put them on a website

http://spbdev.sprigley.com/labels01.jpg
http://spbdev.sprigley.com/labels02.jpg
http://spbdev.sprigley.com/labels03.jpg
http://spbdev.sprigley.com/labelsOK.jpg
http://spbdev.sprigley.com/labelsOKmirror.jpg

Thank you!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Category Labels(X) axis on a chart: Ali Excel Worksheet Functions 2 January 19th 06 11:53 AM
In a bar chart, how do I change the x-axis "category" labels? thermactor Excel Discussion (Misc queries) 1 December 2nd 05 07:19 AM
Align Clustered Column Chart Category Axis Labels Stephanie Charts and Charting in Excel 1 April 7th 05 03:21 PM
Bar chart & Category (x) axis labels Airi A. Charts and Charting in Excel 0 March 15th 05 03:09 PM
Bar chart & Category (x) axis labels Airi A. Charts and Charting in Excel 0 March 15th 05 03:09 PM


All times are GMT +1. The time now is 02:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"