Time axis not accurate on graph

  • Thread starter Thread starter Huck
  • Start date Start date
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
 
Hi

You will need to insert some values for 2001 through 2004 in your source
data.
Make the values =NA()
 
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...
 
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...
-----------------------------------------------------------------------
 
Hi Huck,

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

HTH
Martin
 
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...
 
Back
Top