PC Review


Reply
Thread Tools Rate Thread

Axis labeling

 
 
PattiP
Guest
Posts: n/a
 
      10th Nov 2009
We have created a chart showing daily load for a given month. The bottom
axis shows the days in the month (1-31). When we open the chart on one
computer, all 31 labels show, which is what we want. When we open the file
on another computer, only every 5 labels show, beginning with day 3. All the
data is there, just the labels are missing. Is this an Excel problem or
maybe a setting on the computer? We have the same size computer screens...
--
Patti
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      11th Nov 2009
What kind of chart? Line or column chart: format the axis, and on the
Scale tab (main tab in 2007), enter 1 for Number of Categories Between
Tick mark Labels (even if it says 1, delete this and enter 1).

XY chart: format the axis scale, set the major unit to 1, and in 2003
uncheck the Automatic box, or in 2007 select the Fixed option.

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



PattiP wrote:
> We have created a chart showing daily load for a given month. The bottom
> axis shows the days in the month (1-31). When we open the chart on one
> computer, all 31 labels show, which is what we want. When we open the file
> on another computer, only every 5 labels show, beginning with day 3. All the
> data is there, just the labels are missing. Is this an Excel problem or
> maybe a setting on the computer? We have the same size computer screens...

 
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Labeling X-Axis Taz Microsoft Excel Misc 0 21st May 2009 10:44 PM
Labeling X-Axis Taz Microsoft Excel Misc 0 21st May 2009 10:44 PM
X-axis labeling rrbbmmrr@hotmail.com Microsoft Excel Charting 1 1st Dec 2005 12:28 AM
X-axis labeling Steve Microsoft Excel Charting 2 22nd Dec 2003 04:27 PM
Re: X axis labeling Gary Klass Microsoft Excel Charting 1 26th Aug 2003 05:46 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:17 PM.