Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
The dates on the category (X) axis label do not match data? | Charts and Charting in Excel | |||
Setting x axis scale to time with variable intervals | Charts and Charting in Excel | |||
Formatting dates on x axis of chart...! | Excel Discussion (Misc queries) | |||
grouping dates by week/month/etc. on cat. axis | Charts and Charting in Excel | |||
Using Right Hand Y Axis For An Additional Variable: How ? | Charts and Charting in Excel |