Axis labels on negative values

G

gailb14

My chart has positive and negative values. The axis labels appear at
the 0 value. How do I move them to the side of the chart.
 
D

David Biddulph

gailb14 said:
My chart has positive and negative values. The axis labels appear at
the 0 value. How do I move them to the side of the chart.
Click to expand...

Format Axis/ Scale/ Value (X or Y) axis crosses at ...
 
G

gailb14

My chart has -10 -5 0 5 10
The labels are at the 0. I must not understand your instructions
Value Y axis crosses at category (1)
Value Y axis crosses between categories (checked)
Value Y axis crosses at maximum category (checked)

This is not working
 
G

gailb14

My chart has -10 -5 0 5 10
The labels are at the 0. I must not understand your instructions
Value Y axis crosses at category (1)
Value Y axis crosses between categories (checked)
Value Y axis crosses at maximum category (checked)

This is not working
 
D

David Biddulph

gailb14 said:
My chart has -10 -5 0 5 10
The labels are at the 0. I must not understand your instructions
Value Y axis crosses at category (1)
Value Y axis crosses between categories (checked)
Value Y axis crosses at maximum category (checked)

This is not working
Click to expand...

I don't know what sort of chart you're using. You may find that XY scatter
gives you more flexibility.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Graph Negative Values as Positive Values 0
Data labels along below x axis when y axis has negative values 1
Excel 07 - Stacked Chart Labels on Negative Values 1
Changing the data label position below the chart axis. 2
Stacked Color Charts 1
How to colntrol location of category X axis labels on a bar chart? 4
2007 move axis label & add zero line 1
change the position of X-axis labels 2

Top