View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Category axis formatting and justification

Hi,

Does the 'Value (Y) axis crosses between categories' give you the look
you are after. Double click the category axis and check the Scale tab of
the format dialog.

Cheers
Andy

Brian wrote:
I have been scouring the net looking for information on how to change the way
a category x-axis is aligned relative to a data point. I would like to have
the category tick mark in line with the data point. Excell seems to default
to centering the category under the data point. Below is an example of what
I'm trying to do:

x - data point
*- Category tick mark/line

Excel default:

****************
x Category A
****************
x Category B
****************

Requested format:

x ******************
Category A
x ******************
Category B
********************



Thanks for you help.