GRAPH data labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a line graph with positive & negative numbers.

However, the data labels on the x-axis display directly below the 0 line.

Can anyone tell me how I can format the graph so that the labels show below
the bottom (negative value) line.

Many thanks
 
One way:

CTRL-Click on the vertical axis and choose Format axis... In the scale
tab, uncheck the "Category (X) axis Crosses at:" and enter the Minimum
value (or more negative) in the textbox.
 
Double click on the axis or the numbers for the axis.
select paterns and select Tick mark labels "Low"
 
You must log in or register to reply here.

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

Excel chart does not start at zero. 1
updating graphs 3
y axis category labels on line graph 3
Data Labels Disappearing 0
Scale of Graph Axis 2
plotting line graph with 2 x values 4
Graphing Negative Time 1
Show max and min on a graph 3

Back
Top