A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Line Chart - Problems with labeling X-Axis



 
 
Thread Tools Display Modes
  #1  
Old April 14th, 2010, 04:17 PM posted to microsoft.public.excel.charting
ANDREA
external usenet poster
 
Posts: 273
Default Line Chart - Problems with labeling X-Axis

I am trying to create a line chart but am having trouble with labeling the
X-Axis. The graph is charting temperature on the y-Axis and the date and
time of the testing is running along the X-Axis. There are at least 1096
time entries and I would like the X-axis labels to only display the date
which is only two days and not the time (reason for all the entries). The
X-Axis is currently displaying the time at a 90 degree angle and only one
date at an 180 degree angle, becuase of the numerous time entries the second
date does not show up along the X-Axis. Please help.
  #2  
Old April 14th, 2010, 05:15 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default Line Chart - Problems with labeling X-Axis

Use an XY chart type, format the scale of the X axis accordingly based
on the dates involved. In Excel 2003 and earlier, you can enter dates in
the min and max scale boxes, but in 2007 you'll have to convert to a
regular number: type the date in a cell, and change the number format to
General. Pick an axis major unit of an integral number of days.

Use a number format for the axis labels that includes only the date.

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


On 4/14/2010 11:17 AM, Andrea wrote:
I am trying to create a line chart but am having trouble with labeling the
X-Axis. The graph is charting temperature on the y-Axis and the date and
time of the testing is running along the X-Axis. There are at least 1096
time entries and I would like the X-axis labels to only display the date
which is only two days and not the time (reason for all the entries). The
X-Axis is currently displaying the time at a 90 degree angle and only one
date at an 180 degree angle, becuase of the numerous time entries the second
date does not show up along the X-Axis. Please help.

  #3  
Old April 14th, 2010, 11:10 PM posted to microsoft.public.excel.charting
ANDREA
external usenet poster
 
Posts: 273
Default Line Chart - Problems with labeling X-Axis

Thank you Jon for the reply... I still can not get the axis labels to work
correctly even when I change the chart type to XY scattered.

Please help.. Thanks in advance.

"Jon Peltier" wrote:

Use an XY chart type, format the scale of the X axis accordingly based
on the dates involved. In Excel 2003 and earlier, you can enter dates in
the min and max scale boxes, but in 2007 you'll have to convert to a
regular number: type the date in a cell, and change the number format to
General. Pick an axis major unit of an integral number of days.

Use a number format for the axis labels that includes only the date.

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


On 4/14/2010 11:17 AM, Andrea wrote:
I am trying to create a line chart but am having trouble with labeling the
X-Axis. The graph is charting temperature on the y-Axis and the date and
time of the testing is running along the X-Axis. There are at least 1096
time entries and I would like the X-axis labels to only display the date
which is only two days and not the time (reason for all the entries). The
X-Axis is currently displaying the time at a 90 degree angle and only one
date at an 180 degree angle, becuase of the numerous time entries the second
date does not show up along the X-Axis. Please help.

.

  #4  
Old April 16th, 2010, 01:11 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default Line Chart - Problems with labeling X-Axis

Make sure the time-date data is entered in numerical date and time
format, and Excel recognizes the data as numerical.

Aside from that I don't know, but if you describe how you want it to
work and how it does work, the solution may be more obvious.

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


On 4/14/2010 6:10 PM, Andrea wrote:
Thank you Jon for the reply... I still can not get the axis labels to work
correctly even when I change the chart type to XY scattered.

Please help.. Thanks in advance.

"Jon Peltier" wrote:

Use an XY chart type, format the scale of the X axis accordingly based
on the dates involved. In Excel 2003 and earlier, you can enter dates in
the min and max scale boxes, but in 2007 you'll have to convert to a
regular number: type the date in a cell, and change the number format to
General. Pick an axis major unit of an integral number of days.

Use a number format for the axis labels that includes only the date.

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


On 4/14/2010 11:17 AM, Andrea wrote:
I am trying to create a line chart but am having trouble with labeling the
X-Axis. The graph is charting temperature on the y-Axis and the date and
time of the testing is running along the X-Axis. There are at least 1096
time entries and I would like the X-axis labels to only display the date
which is only two days and not the time (reason for all the entries). The
X-Axis is currently displaying the time at a 90 degree angle and only one
date at an 180 degree angle, becuase of the numerous time entries the second
date does not show up along the X-Axis. Please help.

.

 




Thread Tools
Display Modes

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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:48 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.