View Single Post
  #1   Report Post  
Jayjg
 
Posts: n/a
Default Date updates from worksheet to chart & changes date to a date series! Help!!

Hi,

I have a 2 sheet workbook, one sheet has my data -

Date Kg's
1/5/2003 91.0
2/8/2003 89.1
5/31/2003 90.1
8/21/2003 89.5
1/18/2004 89.9
2/2/2004 88.0
3/6/2004 88.1
4/17/2004 89.2
9/13/2004 88.5
10/4/2004 86.4
11/8/2004 87.3
12/21/2004 88.0

The second sheet has my chart. When the date is carried over to the
chart, the dates are changed to a series of dates, starting 01/05/2003,
02/05/2003 etc... The cells are formated to UK date on both the data
and the chart. Any suggestions?

Thanks

Jamie