Position of X axis labels
 

I have a graph that shows both negative and positive variances on the y axis.
Therefore the zero value axis runs thru the centre of graph and if one wants
to put some labels associated with the x axis ie Jan, Feb, ... these appear
in the middle of the graph not neatly below the plot area as I would prefer.
Any clues?

TIA

--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"

Position of X axis labels
 

Format the y-axis.
you should see an option to set where the x-axis crosses at.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"K_Macd" wrote:

I have a graph that shows both negative and positive variances on the y axis.
Therefore the zero value axis runs thru the centre of graph and if one wants
to put some labels associated with the x axis ie Jan, Feb, ... these appear
in the middle of the graph not neatly below the plot area as I would prefer.
Any clues?

TIA

--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"

Position of X axis labels
 

Keep the axis where it is, to show where zero is. Instead, choose the
"Low" position for the tick labels.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Luke M wrote:
Format the y-axis.
you should see an option to set where the x-axis crosses at.

Position of X axis labels
 

Luke - That did the job!

Jon - Could't quite see that 'low' option (avail in xl2003?) but thanks for
the response

--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"


"Jon Peltier" wrote:

Keep the axis where it is, to show where zero is. Instead, choose the
"Low" position for the tick labels.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Luke M wrote:
Format the y-axis.
you should see an option to set where the x-axis crosses at.

Position of X axis labels
 

In 2003 it's on the Patterns tab of the Format Axis dialog, in the
bottom right of the dialog, under Tick Mark Labels.

In 2007 it's on the Axis Options tab of the Format Axis dialog, 2/3 of
the way down, next to Axis Labels.

The benefit of this approach is that your leave the axis at Y=0, which
helps decode the plotted values.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



K_Macd wrote:
Luke - That did the job!

Jon - Could't quite see that 'low' option (avail in xl2003?) but thanks for
the response