X-Axis labels

R

Robert

I am having trouble using the x-axis labels that I have
chosen in my worksheet. I have chosen a row with the
dates spelled out, however, when I choose this row it
gives me numbers in increments of two. How do I get the
information to show up as January, February, etc.? Thanks.

Robert
 
A

Andy Pope

Hi Robert,

Double click the axis and on the scale tab of the format dialog set the
number of ticklabels between categorys to 1.
You may then need to adjust the fontsize to clearly read the text.

Cheers
Andy
 
R

Robert

I checked and changed it to 1 tick, but that didn't seem
to help as I still have numbers instead of words. Am I
using the right chart? I have also run into a problem now
where my axis category labeling will not allow me to
expand the window so I can see the whole thing. Example
(I typed: "Monthly Breakdown" and all I see is "Month" and
I can't expand the window to see the rest.) The print
preview shows it though. Thanks.
 
A

Andy Pope

Hi Robert,

Is the correct range being used for the category labels?
One way you can check this is via the Source data dialog.

What chart type are you using?

Cheers
Andy
 
J

Jon Peltier

What do the numbers look like? 1, 2, 3, or in the 39-thousands?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

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

Line Chart - Problems with labeling X-Axis 3
Use text descriptors as Y axis units 1
Dynamic series in rows 1
Excel 2007: X-axis labeling 1
Adding a line to a population bar chart 0
Set position of x axis labels 2
change chart primary horizontal axis label or name 1
Time-value axis labels 5

Top