Prev: How do I draw an ellipse on excel, or can I?
Next: Invalid detail on axis
From: water on 9 Apr 2010 21:39
You can try changing the axis to text format

"Midjack" wrote:

> How can I create a time-date graph such that the values are plotted at the
> correct time positions within the date range rather than all on the date
> vertical axis?
>
> N N
> N N
> N N
> N N THIS
> N N
> N N
> Jan 1 Jan 2
>
> Rather than
> N N
> N N
> N N NOT THIS
> N N
> N N
> N N
> Jan 1 Jan 2
>
From: Jon Peltier on 10 Apr 2010 12:27
Even better, use an XY chart. You need the full date and time values in
the cells containing the X values.

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


On 4/9/2010 9:39 PM, water wrote:
> You can try changing the axis to text format
>
> "Midjack" wrote:
>
>> How can I create a time-date graph such that the values are plotted at the
>> correct time positions within the date range rather than all on the date
>> vertical axis?
>>
>> N N
>> N N
>> N N
>> N N THIS
>> N N
>> N N
>> Jan 1 Jan 2
>>
>> Rather than
>> N N
>> N N
>> N N NOT THIS
>> N N
>> N N
>> N N
>> Jan 1 Jan 2
>>
 | 
Pages: 1
Prev: How do I draw an ellipse on excel, or can I?
Next: Invalid detail on axis