Time axis not accurate on graph

H

Huck

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
 
R

Roger Govier

Hi

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

Earl Kiosterud

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.

--
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...
 
E

Earl Kiosterud

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.

--
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...
-----------------------------------------------------------------------
 
M

MartinW

Hi Huck,

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

HTH
Martin
 
H

Huck

Thanks guys for the excellent suggestions.

Huck

MartinW said:
Hi Huck,

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

HTH
Martin
Click to expand...
 
Top