LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Leo Bueno
 
Posts: n/a
Default Variable dates on X axis evenly spaced (should not be)


When I try to do a line plot of the data shown below, all dates are
evenly spaced. Note that the intervals between dates vary, but Excel
(200) treats the dates as labels to evenly spaced points.

How do I go about making the data points reflect the reality that the
date intervals are not uniform.

Thanks.

DATE Var1 Var2
11-12-1999 3.17 1.08
11-24-1999 3.29 2.06
3-20-2000 2.80 2.36
5-7-2002 2.95 1.92
10-15-2002 3.04 1.37
2-18-2003 3.03 1.38
1-7-2004 2.50 0.59
7-15-2005 2.69 0.94

--
=================================================
Do you like wine? Do you live in South Florida?
Visit the MIAMI WINE TASTERS group at
http://groups.yahoo.com/group/miamiWINE
=================================================
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
The dates on the category (X) axis label do not match data? TKGerdie Charts and Charting in Excel 1 July 18th 05 07:05 PM
Setting x axis scale to time with variable intervals webbuzzard Charts and Charting in Excel 1 June 27th 05 07:13 PM
Formatting dates on x axis of chart...! saturnin02 Excel Discussion (Misc queries) 4 January 27th 05 08:55 PM
grouping dates by week/month/etc. on cat. axis Kamal Hood Charts and Charting in Excel 4 January 23rd 05 10:06 AM
Using Right Hand Y Axis For An Additional Variable: How ? Robert11 Charts and Charting in Excel 1 January 17th 05 01:39 PM


All times are GMT +1. The time now is 10:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"