Prev: Hiding Zeros in Data Table
Next: plot two groups of numbers on one series of xy coordinates.
From: Andrea on 14 Apr 2010 11:17
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.
From: Jon Peltier on 14 Apr 2010 12:15
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.
From: Andrea on 14 Apr 2010 18:10
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.
> .
>
From: Jon Peltier on 16 Apr 2010 08:11
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.
>> .
>>
 | 
Pages: 1
Prev: Hiding Zeros in Data Table
Next: plot two groups of numbers on one series of xy coordinates.