PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Not all column titles show on x axis on chart

Reply

Not all column titles show on x axis on chart

 
Thread Tools Rate Thread
Old 10-11-2007, 03:49 PM   #1
=?Utf-8?B?TGVhcm5pbmcgZXhjZWw=?=
Guest
 
Posts: n/a
Default Not all column titles show on x axis on chart


I am making a chart and on the x axis only every other month is showing up on
the graph. I had this problem the other night and I was able to correct it
then but I do not remember what I went under to correct this problem. I need
every month to show up on the x axis
  Reply With Quote
Old 10-11-2007, 09:30 PM   #2
Bernard Liengme
Guest
 
Posts: n/a
Default Re: Not all column titles show on x axis on chart

You need to open the Format Axis dialog for the x-axis (generally, I just
right click the axis and select Format Axis for popup menu) and open the
Scale tab.
Depending on what type of chart you have you need to change the either
a) the Major Units setting, or
b) Number of categories between tick marks
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Learning excel" <Learning excel@discussions.microsoft.com> wrote in message
news:CD147B21-BCF3-42F7-974C-6BDD9A29FD9D@microsoft.com...
>I am making a chart and on the x axis only every other month is showing up
>on
> the graph. I had this problem the other night and I was able to correct
> it
> then but I do not remember what I went under to correct this problem. I
> need
> every month to show up on the x axis



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off