Time axis not accurate on graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Huck - 09 Aug 2007 05:43 GMT

When I graph items against date, the time scale is not even. For example,
if I have the following dates 2000, 2005, 2006, 2007, there will be the same
amount of space between 2000 - 2005 as between 2005-2006. Is there a way to
make the time scale correct?

thanks for any help.

Huck

Reply to this Message

Roger Govier - 09 Aug 2007 08:26 GMT

Hi

You will need to insert some values for 2001 through 2004 in your source
data.
Make the values =NA()

Signature

Regards
Roger Govier

> When I graph items against date, the time scale is not even. For example,
> if I have the following dates 2000, 2005, 2006, 2007, there will be the
[quoted text clipped - 4 lines]
>
> Huck

Reply to this Message

Earl Kiosterud - 09 Aug 2007 15:34 GMT

Huck,

You have a category axis. The categories (items on the x axis) are evenly spaced,
regardless of content. You can change the x axis from category to time-scale. Chart -
Chart options - Axes.

Signature

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------

> When I graph items against date, the time scale is not even. For example, if I have the
> following dates 2000, 2005, 2006, 2007, there will be the same amount of space between
[quoted text clipped - 3 lines]
>
> Huck

Reply to this Message

Earl Kiosterud - 09 Aug 2007 15:53 GMT

Huck

I didn't mention that you may also want to change the base unit for the x axis after
changing to time-scale. Select the axis (click any label on it), right-click - Format axis,
Scale tab.

Signature

> Huck,
>
[quoted text clipped - 9 lines]
>>
>> Huck

Reply to this Message

MartinW - 10 Aug 2007 06:35 GMT

Hi Huck,

Sounds like you are using a line chart.
An XY scatter may give you better results.

HTH
Martin

> When I graph items against date, the time scale is not even. For example,
> if I have the following dates 2000, 2005, 2006, 2007, there will be the
[quoted text clipped - 4 lines]
>
> Huck

Reply to this Message

Huck - 15 Aug 2007 03:26 GMT

Thanks guys for the excellent suggestions.

Huck

> Hi Huck,
>
[quoted text clipped - 12 lines]
>>
>> Huck

Reply to this Message