Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > When building a chart Dates are been included that are not in thedate range
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 16
Default When building a chart Dates are been included that are not in thedate range
Hi All,

I have this data that I am trying to put into a scatter chart, there
are 4 colums A-D starting at row 1 to 367 I have the date entered in
column A from 1st Jan 2008 to 31st Dec 2009 entered as = Date
(2008,01,01) in cell A2 and A3 onwards is =A2+3, A3+1 etc etc, the
other 3 columns is random data from those dates.

When I select all the data range and press F11 to create a chart it
looks fine but when I right click and select scatter chart with smooth
line I get an X axis starting November 2007, which isn't in the
range.

Any Ideas on what i'm doing wrong?

Kind Regards
Mark

A B C D
Date Flow Presure Loss
01-Jan-08 211.4 514.6 0.0
02-Jan-08 231.6 462.2 8.6
03-Jan-08 231.6 473.8 0.0
04-Jan-08 251.7 501.2 0.0
05-Jan-08 259.0 463.6 0.0
06-Jan-08 261.5 430.4 0.0
07-Jan-08 261.3 460.1 0.0
08-Jan-08 260.4 443.7 0.0
09-Jan-08 256.9 446.0 0.0
10-Jan-08 262.0 431.5 0.0
11-Jan-08 259.0 437.6 0.0
12-Jan-08 252.0 439.4 0.0
13-Jan-08 248.1 441.9 0.0
14-Jan-08 217.8 403.3 0.0
15-Jan-08 211.1 442.2 0.0
16-Jan-08 226.3 382.5 0.0
17-Jan-08 242.6 384.4 0.0
18-Jan-08 238.1 375.4 0.0
19-Jan-08 228.7 403.3 0.0
20-Jan-08 29.4 0.0 0.0
21-Jan-08 1.9 0.0 0.0
22-Jan-08 2.0 0.0 0.0
23-Jan-08 2.4 0.0 0.0
24-Jan-08 2.4 0.0 0.0
25-Jan-08 2.7 0.0 0.0
26-Jan-08 2.7 0.0 0.0
27-Jan-08 2.8 0.0 0.0
28-Jan-08 2.9 0.0 0.0
29-Jan-08 2.9 0.0 0.0
30-Jan-08 3.1 0.0 0.0
31-Jan-08 3.2 0.0 0.0
01-Feb-08 4.6 0.0 0.0
02-Feb-08 31.5 0.0 0.0
03-Feb-08 200.1 0.0 0.0
04-Feb-08 191.9 0.0 0.0
05-Feb-08 196.2 497.9 0.0
06-Feb-08 175.2 522.5 0.0
07-Feb-08 180.4 531.2 0.0
08-Feb-08 18.5 64.9 0.0
09-Feb-08 183.0 763.5 0.0
10-Feb-08 190.5 746.8 0.0
11-Feb-08 195.5 677.7 0.0
12-Feb-08 196.7 627.4 0.0
13-Feb-08 188.1 614.3 9.5
14-Feb-08 194.5 566.6 8.1
15-Feb-08 236.7 451.1 0.0
16-Feb-08 235.0 397.7 0.0
17-Feb-08 233.2 504.3 0.0
18-Feb-08 220.0 566.4 0.0
19-Feb-08 219.1 565.7 0.0
20-Feb-08 216.4 571.0 0.0
21-Feb-08 227.6 497.2 0.0
22-Feb-08 235.8 435.6 0.0
23-Feb-08 240.5 489.4 0.0
24-Feb-08 224.5 569.0 0.0
25-Feb-08 226.6 543.7 0.0
26-Feb-08 230.4 588.2 0.0
27-Feb-08 237.7 563.3 0.0
28-Feb-08 235.2 553.6 0.0
29-Feb-08 205.2 537.9 0.0
01-Mar-08 222.0 522.7 0.0
02-Mar-08 211.4 482.0 0.0
03-Mar-08 248.8 478.7 11.1
04-Mar-08 211.9 457.4 0.0
05-Mar-08 204.1 465.9 13.9
06-Mar-08 93.2 238.1 0.0
07-Mar-08 1.0 7.8 0.0
08-Mar-08 0.0 6.2 0.0
09-Mar-08 0.0 8.7 0.0
10-Mar-08 0.0 6.6 0.0
11-Mar-08 0.0 7.0 0.0
12-Mar-08 0.0 7.3 0.0
13-Mar-08 0.0 7.0 0.0
14-Mar-08 0.0 20.3 0.0
15-Mar-08 0.0 41.6 0.0
16-Mar-08 0.0 36.9 0.0
17-Mar-08 0.0 45.4 0.0
18-Mar-08 94.5 37.0 0.0
19-Mar-08 207.0 677.4 0.0
20-Mar-08 181.4 379.6 0.0
21-Mar-08 210.0 363.1 0.0
22-Mar-08 204.6 346.1 0.0
23-Mar-08 206.4 399.1 0.0
24-Mar-08 203.7 426.4 0.0
25-Mar-08 205.3 417.4 0.0
26-Mar-08 233.6 429.3 7.4
27-Mar-08 239.3 419.7 0.0
28-Mar-08 257.0 458.7 0.0
29-Mar-08 264.3 463.1 0.0
30-Mar-08 266.0 468.1 0.0
31-Mar-08 261.0 461.9 11.3
01-Apr-08 233.8 420.0 12.9
02-Apr-08 233.5 441.7 13.2
03-Apr-08 267.9 506.5 10.9
04-Apr-08 265.3 448.8 0.0
05-Apr-08 264.9 466.2 0.0
06-Apr-08 267.5 498.1 26.2
07-Apr-08 238.8 465.9 0.0
08-Apr-08 233.9 430.0 0.0
09-Apr-08 238.5 454.4 39.3
10-Apr-08 238.8 558.3 0.0
11-Apr-08 252.1 563.8 0.0
12-Apr-08 263.0 540.1 0.0
13-Apr-08 252.3 474.8 13.8
14-Apr-08 259.8 476.0 23.2
15-Apr-08 260.7 560.2 0.0
16-Apr-08 257.0 514.3 0.0
17-Apr-08 258.5 449.6 12.9
18-Apr-08 261.6 415.3 0.0
19-Apr-08 260.3 423.1 0.0
20-Apr-08 262.5 426.7 0.0
21-Apr-08 259.1 457.2 9.3
22-Apr-08 269.4 444.3 11.0
23-Apr-08 254.7 421.2 10.5
24-Apr-08 250.7 356.0 11.6
25-Apr-08 258.8 397.6 0.0
26-Apr-08 222.2 372.9 0.0
27-Apr-08 225.3 373.2 10.3
28-Apr-08 229.5 408.6 10.9
29-Apr-08 239.8 402.7 10.6
30-Apr-08 5.6 0.0 0.0
01-May-08 5.6 11.9 0.0
02-May-08 257.5 335.4 0.0
03-May-08 254.6 337.8 0.0
04-May-08 261.9 375.1 0.0
05-May-08 259.0 355.8 9.0
06-May-08 255.2 348.4 10.1
07-May-08 253.2 304.0 0.0
08-May-08 245.2 331.3 12.1
09-May-08 216.1 351.2 0.0
10-May-08 188.6 457.4 0.0
11-May-08 203.3 439.5 8.6
12-May-08 187.8 533.6 0.0
13-May-08 183.6 587.1 0.0
14-May-08 156.4 100.6 9.1
15-May-08 261.9 291.9 0.0
16-May-08 262.2 261.7 0.0
17-May-08 255.8 279.3 0.0
18-May-08 228.7 244.1 0.0
19-May-08 163.0 184.3 0.0
20-May-08 232.2 237.8 8.0
21-May-08 261.0 305.5 0.0
22-May-08 246.6 298.6 0.0
23-May-08 189.9 228.8 0.0
24-May-08 253.1 327.7 0.0
25-May-08 265.4 351.7 0.0
26-May-08 248.2 338.2 0.0
27-May-08 239.4 341.7 0.0
28-May-08 253.7 344.6 0.0
29-May-08 248.0 325.2 0.0
30-May-08 251.3 340.5 0.0
31-May-08 246.7 340.2 0.0
01-Jun-08 253.4 355.8 11.6
02-Jun-08 248.9 362.1 0.0
03-Jun-08 247.4 352.6 0.0
04-Jun-08 251.6 394.8 10.6
05-Jun-08 250.2 425.7 0.0
06-Jun-08 245.4 398.6 12.5
07-Jun-08 251.8 370.3 0.0
08-Jun-08 239.0 355.2 9.8
09-Jun-08 244.2 342.9 0.0
10-Jun-08 210.5 342.7 14.1
11-Jun-08 238.9 358.8 12.8
12-Jun-08 208.5 427.1 11.4
13-Jun-08 256.0 355.2 10.4
14-Jun-08 249.3 403.0 0.0
15-Jun-08 249.8 402.2 11.3
16-Jun-08 256.7 380.9 11.1
17-Jun-08 247.0 375.5 13.3
18-Jun-08 256.1 384.5 13.1
19-Jun-08 254.7 423.3 0.0
20-Jun-08 252.0 427.3 17.8
21-Jun-08 234.8 388.9 0.0
22-Jun-08 238.2 380.1 10.3
23-Jun-08 256.9 417.9 12.2
24-Jun-08 239.2 380.7 13.2
25-Jun-08 243.9 390.2 0.0
26-Jun-08 245.9 392.8 10.5
27-Jun-08 254.1 383.3 0.0
28-Jun-08 256.7 373.5 11.3
29-Jun-08 234.7 343.4 11.6
30-Jun-08 234.9 361.0 11.5
01-Jul-08 220.7 355.0 0.0
02-Jul-08 254.5 391.3 0.0
03-Jul-08 263.9 401.1 0.0
04-Jul-08 255.5 391.9 0.0
05-Jul-08 257.4 409.6 0.0
06-Jul-08 244.7 390.1 0.0
07-Jul-08 202.7 396.4 0.0
08-Jul-08 253.7 404.4 0.0
09-Jul-08 255.5 398.7 0.0
10-Jul-08 259.4 395.6 0.0
11-Jul-08 235.1 386.1 0.0
12-Jul-08 249.3 376.9 0.0
13-Jul-08 260.1 388.0 11.3
14-Jul-08 253.3 382.7 0.0
15-Jul-08 249.6 390.7 0.0
16-Jul-08 248.4 412.0 8.8
17-Jul-08 248.3 414.1 11.0
18-Jul-08 212.8 331.7 15.3
19-Jul-08 164.8 383.3 11.5
20-Jul-08 222.8 466.8 6.7
21-Jul-08 215.1 447.0 0.0
22-Jul-08 216.7 497.1 10.1
23-Jul-08 233.2 522.9 0.0
24-Jul-08 253.0 553.5 7.2
25-Jul-08 237.7 527.7 4.5
26-Jul-08 238.6 514.2 0.0
27-Jul-08 241.0 633.7 9.2
28-Jul-08 241.2 581.5 0.0
29-Jul-08 261.9 556.1 6.5
30-Jul-08 260.3 492.6 12.0
31-Jul-08 208.9 367.9 13.2
01-Aug-08 204.7 366.9 7.1
02-Aug-08 184.4 373.6 6.3
03-Aug-08 232.1 419.5 5.5
04-Aug-08 238.0 390.5 5.2
05-Aug-08 211.0 452.3 6.5
06-Aug-08 225.1 471.4 3.5
07-Aug-08 223.7 489.0 5.6
08-Aug-08 228.5 388.1 10.1
09-Aug-08 227.4 490.2 0.0
10-Aug-08 234.2 474.0 0.0
11-Aug-08 235.4 457.0 0.0
12-Aug-08 260.1 490.0 6.4
13-Aug-08 239.7 513.1 0.0
14-Aug-08 259.1 476.3 0.0
15-Aug-08 263.7 488.7 6.7
16-Aug-08 213.4 421.0 5.0
17-Aug-08 240.5 421.4 2.5
18-Aug-08 236.2 394.6 7.3
19-Aug-08 249.7 449.2 5.9
20-Aug-08 253.1 497.1 8.5
21-Aug-08 259.1 517.6 10.0
22-Aug-08 257.6 586.1 9.1
23-Aug-08 259.6 567.9 0.0
24-Aug-08 247.9 522.0 10.2
25-Aug-08 206.4 451.1 0.0
26-Aug-08 250.9 538.5 10.9
27-Aug-08 251.6 516.7 0.0
28-Aug-08 238.2 521.1 8.7
29-Aug-08 222.9 516.3 0.0
30-Aug-08 221.0 545.7 0.0
31-Aug-08 235.1 610.8 4.5
01-Sep-08 233.7 526.9 8.0
02-Sep-08 252.5 595.1 5.9
03-Sep-08 250.0 493.9 0.0
04-Sep-08 249.3 481.4 0.0
05-Sep-08 245.7 453.1 0.0
06-Sep-08 202.4 429.4 8.2
07-Sep-08 190.0 440.1 10.0
08-Sep-08 194.1 446.3 3.7
09-Sep-08 194.4 318.9 8.0
10-Sep-08 212.6 399.0 5.7
11-Sep-08 210.8 363.9 7.2
12-Sep-08 181.8 323.2 0.0
13-Sep-08 155.3 140.1 0.0
14-Sep-08 155.3 162.4 0.0
15-Sep-08 169.1 160.1 0.0
16-Sep-08 2.6 55.4 0.0
17-Sep-08 3.0 12.2 0.0
18-Sep-08 2.3 12.0 0.0
19-Sep-08 2.4 12.0 0.0
20-Sep-08 2.4 5.5 0.0
21-Sep-08 2.5 5.6 0.0
22-Sep-08 2.7 5.5 0.0
23-Sep-08 2.7 5.8 0.0
24-Sep-08 3.8 5.5 0.0
25-Sep-08 3.5 6.8 0.0
26-Sep-08 3.6 5.6 0.0
27-Sep-08 2.6 5.6 0.0
28-Sep-08 3.4 7.6 0.0
29-Sep-08 2.7 5.8 0.0
30-Sep-08 3.5 5.5 0.0
01-Oct-08 4.0 5.5 0.0
02-Oct-08 5.8 6.8 0.0
03-Oct-08 5.1 5.5 0.0
04-Oct-08 5.2 6.2 0.0
05-Oct-08 4.9 5.5 0.0
06-Oct-08 3.3 10.2 0.0
07-Oct-08 3.5 5.6 0.0
08-Oct-08 3.4 5.6 0.0
09-Oct-08 3.6 5.6 0.0
10-Oct-08 4.5 5.6 0.0
11-Oct-08 64.0 57.5 0.0
12-Oct-08 168.3 85.4 0.0
13-Oct-08 168.4 85.6 0.0
14-Oct-08 175.2 181.0 0.0
15-Oct-08 191.0 229.2 0.0
16-Oct-08 3.4 11.9 0.0
17-Oct-08 3.6 12.0 0.0
18-Oct-08 2.6 12.1 0.0
19-Oct-08 2.6 12.1 0.0
20-Oct-08 2.8 12.1 0.0
21-Oct-08 6.9 11.9 0.0
22-Oct-08 235.2 341.8 21.0
23-Oct-08 201.6 433.2 22.6
24-Oct-08 251.3 401.1 10.6
25-Oct-08 260.8 369.2 0.0
26-Oct-08 228.1 341.9 20.4
27-Oct-08 210.0 377.8 23.0
28-Oct-08 209.5 380.3 24.2
29-Oct-08 206.6 332.2 26.0
30-Oct-08 216.5 325.7 0.0
31-Oct-08 179.7 313.6 29.0
01-Nov-08 197.1 341.2 23.3
02-Nov-08 201.4 312.0 19.5
03-Nov-08 182.6 272.5 27.7
04-Nov-08 180.2 298.5 21.1
05-Nov-08 189.5 326.3 22.9
06-Nov-08 184.1 320.7 26.7
07-Nov-08 194.9 351.8 25.4
08-Nov-08 194.0 347.0 29.6
09-Nov-08 190.5 400.9 26.0
10-Nov-08 194.7 359.0 21.7
11-Nov-08 200.4 389.1 21.2
12-Nov-08 198.3 373.3 19.7
13-Nov-08 178.1 346.1 27.6
14-Nov-08 115.6 287.3 20.1
15-Nov-08 185.4 333.3 19.1
16-Nov-08 219.2 372.5 16.5
17-Nov-08 233.7 367.6 0.0
18-Nov-08 174.7 339.5 0.0
19-Nov-08 49.0 63.0 0.0
20-Nov-08 190.7 446.5 0.0
21-Nov-08 188.4 586.1 20.6
22-Nov-08 187.0 475.4 15.9
23-Nov-08 196.2 432.7 14.0
24-Nov-08 224.8 435.3 15.8
25-Nov-08 211.3 461.2 11.9
26-Nov-08 236.3 572.4 7.2
27-Nov-08 254.0 645.9 0.0
28-Nov-08 248.6 581.8 0.0
29-Nov-08 247.3 469.1 0.0
30-Nov-08 235.5 508.6 0.0
01-Dec-08 234.9 473.7 7.8
02-Dec-08 229.6 499.6 0.0
03-Dec-08 196.7 333.9 0.0
04-Dec-08 212.2 464.5 0.0
05-Dec-08 189.4 410.0 15.1
06-Dec-08 202.8 371.0 0.0
07-Dec-08 219.1 396.9 0.0
08-Dec-08 217.6 400.2 16.0
09-Dec-08 218.7 374.0 8.2
10-Dec-08 182.2 344.8 16.2
11-Dec-08 207.4 427.3 0.0
12-Dec-08 182.8 411.2 0.0
13-Dec-08 233.7 417.0 9.9
14-Dec-08 233.5 455.4 3.0
15-Dec-08 206.1 493.5 12.3
16-Dec-08 205.6 464.4 14.2
17-Dec-08 203.0 429.4 18.7
18-Dec-08 202.6 443.3 6.6
19-Dec-08 203.8 416.5 0.0
20-Dec-08 203.0 430.5 9.9
21-Dec-08 208.0 396.9 16.8
22-Dec-08 223.1 405.3 14.1
23-Dec-08 211.1 356.7 12.9
24-Dec-08 236.2 436.0 10.8
25-Dec-08 232.2 485.3 0.0
26-Dec-08 239.4 516.5 0.0
27-Dec-08 248.0 517.6 18.7
28-Dec-08 250.2 497.8 12.7
29-Dec-08 241.2 465.2 11.9
30-Dec-08 249.5 492.3 13.7
31-Dec-08 246.7 492.1 4.0
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 8,651
Default When building a chart Dates are been included that are not in the date range
It'll be because it's trying to put tick marks on the chart at round
numbers. Its first round number is39400, which is 14 Nov 07.

I wouldn't normally recommend changing from XY to line chart, but you might
find this helps. Change to line, then Chart Options/ Axes/ select
timescale, then Format Axis/ Scale and choose an appropriate tick mark
interval. But with line chart you won't be able to choose smoothed (but I
wouldn't normally choose smoothed anyway).
--
David Biddulph


"Sh0t2bts" wrote in message
...
Hi All,

I have this data that I am trying to put into a scatter chart, there
are 4 colums A-D starting at row 1 to 367 I have the date entered in
column A from 1st Jan 2008 to 31st Dec 2009 entered as = Date
(2008,01,01) in cell A2 and A3 onwards is =A2+3, A3+1 etc etc, the
other 3 columns is random data from those dates.

When I select all the data range and press F11 to create a chart it
looks fine but when I right click and select scatter chart with smooth
line I get an X axis starting November 2007, which isn't in the
range.

Any Ideas on what i'm doing wrong?

Kind Regards
Mark

A B C D
Date Flow Presure Loss
01-Jan-08 211.4 514.6 0.0
02-Jan-08 231.6 462.2 8.6
03-Jan-08 231.6 473.8 0.0
04-Jan-08 251.7 501.2 0.0
05-Jan-08 259.0 463.6 0.0
06-Jan-08 261.5 430.4 0.0
07-Jan-08 261.3 460.1 0.0
08-Jan-08 260.4 443.7 0.0
09-Jan-08 256.9 446.0 0.0
10-Jan-08 262.0 431.5 0.0
11-Jan-08 259.0 437.6 0.0
12-Jan-08 252.0 439.4 0.0
13-Jan-08 248.1 441.9 0.0
14-Jan-08 217.8 403.3 0.0
15-Jan-08 211.1 442.2 0.0
16-Jan-08 226.3 382.5 0.0
17-Jan-08 242.6 384.4 0.0
18-Jan-08 238.1 375.4 0.0
19-Jan-08 228.7 403.3 0.0
20-Jan-08 29.4 0.0 0.0
21-Jan-08 1.9 0.0 0.0
22-Jan-08 2.0 0.0 0.0
23-Jan-08 2.4 0.0 0.0
24-Jan-08 2.4 0.0 0.0
25-Jan-08 2.7 0.0 0.0
26-Jan-08 2.7 0.0 0.0
27-Jan-08 2.8 0.0 0.0
28-Jan-08 2.9 0.0 0.0
29-Jan-08 2.9 0.0 0.0
30-Jan-08 3.1 0.0 0.0
31-Jan-08 3.2 0.0 0.0
01-Feb-08 4.6 0.0 0.0
02-Feb-08 31.5 0.0 0.0
03-Feb-08 200.1 0.0 0.0
04-Feb-08 191.9 0.0 0.0
05-Feb-08 196.2 497.9 0.0
06-Feb-08 175.2 522.5 0.0
07-Feb-08 180.4 531.2 0.0
08-Feb-08 18.5 64.9 0.0
09-Feb-08 183.0 763.5 0.0
10-Feb-08 190.5 746.8 0.0
11-Feb-08 195.5 677.7 0.0
12-Feb-08 196.7 627.4 0.0
13-Feb-08 188.1 614.3 9.5
14-Feb-08 194.5 566.6 8.1
15-Feb-08 236.7 451.1 0.0
16-Feb-08 235.0 397.7 0.0
17-Feb-08 233.2 504.3 0.0
18-Feb-08 220.0 566.4 0.0
19-Feb-08 219.1 565.7 0.0
20-Feb-08 216.4 571.0 0.0
21-Feb-08 227.6 497.2 0.0
22-Feb-08 235.8 435.6 0.0
23-Feb-08 240.5 489.4 0.0
24-Feb-08 224.5 569.0 0.0
25-Feb-08 226.6 543.7 0.0
26-Feb-08 230.4 588.2 0.0
27-Feb-08 237.7 563.3 0.0
28-Feb-08 235.2 553.6 0.0
29-Feb-08 205.2 537.9 0.0
01-Mar-08 222.0 522.7 0.0
02-Mar-08 211.4 482.0 0.0
03-Mar-08 248.8 478.7 11.1
04-Mar-08 211.9 457.4 0.0
05-Mar-08 204.1 465.9 13.9
06-Mar-08 93.2 238.1 0.0
07-Mar-08 1.0 7.8 0.0
08-Mar-08 0.0 6.2 0.0
09-Mar-08 0.0 8.7 0.0
10-Mar-08 0.0 6.6 0.0
11-Mar-08 0.0 7.0 0.0
12-Mar-08 0.0 7.3 0.0
13-Mar-08 0.0 7.0 0.0
14-Mar-08 0.0 20.3 0.0
15-Mar-08 0.0 41.6 0.0
16-Mar-08 0.0 36.9 0.0
17-Mar-08 0.0 45.4 0.0
18-Mar-08 94.5 37.0 0.0
19-Mar-08 207.0 677.4 0.0
20-Mar-08 181.4 379.6 0.0
21-Mar-08 210.0 363.1 0.0
22-Mar-08 204.6 346.1 0.0
23-Mar-08 206.4 399.1 0.0
24-Mar-08 203.7 426.4 0.0
25-Mar-08 205.3 417.4 0.0
26-Mar-08 233.6 429.3 7.4
27-Mar-08 239.3 419.7 0.0
28-Mar-08 257.0 458.7 0.0
29-Mar-08 264.3 463.1 0.0
30-Mar-08 266.0 468.1 0.0
31-Mar-08 261.0 461.9 11.3
01-Apr-08 233.8 420.0 12.9
02-Apr-08 233.5 441.7 13.2
03-Apr-08 267.9 506.5 10.9
04-Apr-08 265.3 448.8 0.0
05-Apr-08 264.9 466.2 0.0
06-Apr-08 267.5 498.1 26.2
07-Apr-08 238.8 465.9 0.0
08-Apr-08 233.9 430.0 0.0
09-Apr-08 238.5 454.4 39.3
10-Apr-08 238.8 558.3 0.0
11-Apr-08 252.1 563.8 0.0
12-Apr-08 263.0 540.1 0.0
13-Apr-08 252.3 474.8 13.8
14-Apr-08 259.8 476.0 23.2
15-Apr-08 260.7 560.2 0.0
16-Apr-08 257.0 514.3 0.0
17-Apr-08 258.5 449.6 12.9
18-Apr-08 261.6 415.3 0.0
19-Apr-08 260.3 423.1 0.0
20-Apr-08 262.5 426.7 0.0
21-Apr-08 259.1 457.2 9.3
22-Apr-08 269.4 444.3 11.0
23-Apr-08 254.7 421.2 10.5
24-Apr-08 250.7 356.0 11.6
25-Apr-08 258.8 397.6 0.0
26-Apr-08 222.2 372.9 0.0
27-Apr-08 225.3 373.2 10.3
28-Apr-08 229.5 408.6 10.9
29-Apr-08 239.8 402.7 10.6
30-Apr-08 5.6 0.0 0.0
01-May-08 5.6 11.9 0.0
02-May-08 257.5 335.4 0.0
03-May-08 254.6 337.8 0.0
04-May-08 261.9 375.1 0.0
05-May-08 259.0 355.8 9.0
06-May-08 255.2 348.4 10.1
07-May-08 253.2 304.0 0.0
08-May-08 245.2 331.3 12.1
09-May-08 216.1 351.2 0.0
10-May-08 188.6 457.4 0.0
11-May-08 203.3 439.5 8.6
12-May-08 187.8 533.6 0.0
13-May-08 183.6 587.1 0.0
14-May-08 156.4 100.6 9.1
15-May-08 261.9 291.9 0.0
16-May-08 262.2 261.7 0.0
17-May-08 255.8 279.3 0.0
18-May-08 228.7 244.1 0.0
19-May-08 163.0 184.3 0.0
20-May-08 232.2 237.8 8.0
21-May-08 261.0 305.5 0.0
22-May-08 246.6 298.6 0.0
23-May-08 189.9 228.8 0.0
24-May-08 253.1 327.7 0.0
25-May-08 265.4 351.7 0.0
26-May-08 248.2 338.2 0.0
27-May-08 239.4 341.7 0.0
28-May-08 253.7 344.6 0.0
29-May-08 248.0 325.2 0.0
30-May-08 251.3 340.5 0.0
31-May-08 246.7 340.2 0.0
01-Jun-08 253.4 355.8 11.6
02-Jun-08 248.9 362.1 0.0
03-Jun-08 247.4 352.6 0.0
04-Jun-08 251.6 394.8 10.6
05-Jun-08 250.2 425.7 0.0
06-Jun-08 245.4 398.6 12.5
07-Jun-08 251.8 370.3 0.0
08-Jun-08 239.0 355.2 9.8
09-Jun-08 244.2 342.9 0.0
10-Jun-08 210.5 342.7 14.1
11-Jun-08 238.9 358.8 12.8
12-Jun-08 208.5 427.1 11.4
13-Jun-08 256.0 355.2 10.4
14-Jun-08 249.3 403.0 0.0
15-Jun-08 249.8 402.2 11.3
16-Jun-08 256.7 380.9 11.1
17-Jun-08 247.0 375.5 13.3
18-Jun-08 256.1 384.5 13.1
19-Jun-08 254.7 423.3 0.0
20-Jun-08 252.0 427.3 17.8
21-Jun-08 234.8 388.9 0.0
22-Jun-08 238.2 380.1 10.3
23-Jun-08 256.9 417.9 12.2
24-Jun-08 239.2 380.7 13.2
25-Jun-08 243.9 390.2 0.0
26-Jun-08 245.9 392.8 10.5
27-Jun-08 254.1 383.3 0.0
28-Jun-08 256.7 373.5 11.3
29-Jun-08 234.7 343.4 11.6
30-Jun-08 234.9 361.0 11.5
01-Jul-08 220.7 355.0 0.0
02-Jul-08 254.5 391.3 0.0
03-Jul-08 263.9 401.1 0.0
04-Jul-08 255.5 391.9 0.0
05-Jul-08 257.4 409.6 0.0
06-Jul-08 244.7 390.1 0.0
07-Jul-08 202.7 396.4 0.0
08-Jul-08 253.7 404.4 0.0
09-Jul-08 255.5 398.7 0.0
10-Jul-08 259.4 395.6 0.0
11-Jul-08 235.1 386.1 0.0
12-Jul-08 249.3 376.9 0.0
13-Jul-08 260.1 388.0 11.3
14-Jul-08 253.3 382.7 0.0
15-Jul-08 249.6 390.7 0.0
16-Jul-08 248.4 412.0 8.8
17-Jul-08 248.3 414.1 11.0
18-Jul-08 212.8 331.7 15.3
19-Jul-08 164.8 383.3 11.5
20-Jul-08 222.8 466.8 6.7
21-Jul-08 215.1 447.0 0.0
22-Jul-08 216.7 497.1 10.1
23-Jul-08 233.2 522.9 0.0
24-Jul-08 253.0 553.5 7.2
25-Jul-08 237.7 527.7 4.5
26-Jul-08 238.6 514.2 0.0
27-Jul-08 241.0 633.7 9.2
28-Jul-08 241.2 581.5 0.0
29-Jul-08 261.9 556.1 6.5
30-Jul-08 260.3 492.6 12.0
31-Jul-08 208.9 367.9 13.2
01-Aug-08 204.7 366.9 7.1
02-Aug-08 184.4 373.6 6.3
03-Aug-08 232.1 419.5 5.5
04-Aug-08 238.0 390.5 5.2
05-Aug-08 211.0 452.3 6.5
06-Aug-08 225.1 471.4 3.5
07-Aug-08 223.7 489.0 5.6
08-Aug-08 228.5 388.1 10.1
09-Aug-08 227.4 490.2 0.0
10-Aug-08 234.2 474.0 0.0
11-Aug-08 235.4 457.0 0.0
12-Aug-08 260.1 490.0 6.4
13-Aug-08 239.7 513.1 0.0
14-Aug-08 259.1 476.3 0.0
15-Aug-08 263.7 488.7 6.7
16-Aug-08 213.4 421.0 5.0
17-Aug-08 240.5 421.4 2.5
18-Aug-08 236.2 394.6 7.3
19-Aug-08 249.7 449.2 5.9
20-Aug-08 253.1 497.1 8.5
21-Aug-08 259.1 517.6 10.0
22-Aug-08 257.6 586.1 9.1
23-Aug-08 259.6 567.9 0.0
24-Aug-08 247.9 522.0 10.2
25-Aug-08 206.4 451.1 0.0
26-Aug-08 250.9 538.5 10.9
27-Aug-08 251.6 516.7 0.0
28-Aug-08 238.2 521.1 8.7
29-Aug-08 222.9 516.3 0.0
30-Aug-08 221.0 545.7 0.0
31-Aug-08 235.1 610.8 4.5
01-Sep-08 233.7 526.9 8.0
02-Sep-08 252.5 595.1 5.9
03-Sep-08 250.0 493.9 0.0
04-Sep-08 249.3 481.4 0.0
05-Sep-08 245.7 453.1 0.0
06-Sep-08 202.4 429.4 8.2
07-Sep-08 190.0 440.1 10.0
08-Sep-08 194.1 446.3 3.7
09-Sep-08 194.4 318.9 8.0
10-Sep-08 212.6 399.0 5.7
11-Sep-08 210.8 363.9 7.2
12-Sep-08 181.8 323.2 0.0
13-Sep-08 155.3 140.1 0.0
14-Sep-08 155.3 162.4 0.0
15-Sep-08 169.1 160.1 0.0
16-Sep-08 2.6 55.4 0.0
17-Sep-08 3.0 12.2 0.0
18-Sep-08 2.3 12.0 0.0
19-Sep-08 2.4 12.0 0.0
20-Sep-08 2.4 5.5 0.0
21-Sep-08 2.5 5.6 0.0
22-Sep-08 2.7 5.5 0.0
23-Sep-08 2.7 5.8 0.0
24-Sep-08 3.8 5.5 0.0
25-Sep-08 3.5 6.8 0.0
26-Sep-08 3.6 5.6 0.0
27-Sep-08 2.6 5.6 0.0
28-Sep-08 3.4 7.6 0.0
29-Sep-08 2.7 5.8 0.0
30-Sep-08 3.5 5.5 0.0
01-Oct-08 4.0 5.5 0.0
02-Oct-08 5.8 6.8 0.0
03-Oct-08 5.1 5.5 0.0
04-Oct-08 5.2 6.2 0.0
05-Oct-08 4.9 5.5 0.0
06-Oct-08 3.3 10.2 0.0
07-Oct-08 3.5 5.6 0.0
08-Oct-08 3.4 5.6 0.0
09-Oct-08 3.6 5.6 0.0
10-Oct-08 4.5 5.6 0.0
11-Oct-08 64.0 57.5 0.0
12-Oct-08 168.3 85.4 0.0
13-Oct-08 168.4 85.6 0.0
14-Oct-08 175.2 181.0 0.0
15-Oct-08 191.0 229.2 0.0
16-Oct-08 3.4 11.9 0.0
17-Oct-08 3.6 12.0 0.0
18-Oct-08 2.6 12.1 0.0
19-Oct-08 2.6 12.1 0.0
20-Oct-08 2.8 12.1 0.0
21-Oct-08 6.9 11.9 0.0
22-Oct-08 235.2 341.8 21.0
23-Oct-08 201.6 433.2 22.6
24-Oct-08 251.3 401.1 10.6
25-Oct-08 260.8 369.2 0.0
26-Oct-08 228.1 341.9 20.4
27-Oct-08 210.0 377.8 23.0
28-Oct-08 209.5 380.3 24.2
29-Oct-08 206.6 332.2 26.0
30-Oct-08 216.5 325.7 0.0
31-Oct-08 179.7 313.6 29.0
01-Nov-08 197.1 341.2 23.3
02-Nov-08 201.4 312.0 19.5
03-Nov-08 182.6 272.5 27.7
04-Nov-08 180.2 298.5 21.1
05-Nov-08 189.5 326.3 22.9
06-Nov-08 184.1 320.7 26.7
07-Nov-08 194.9 351.8 25.4
08-Nov-08 194.0 347.0 29.6
09-Nov-08 190.5 400.9 26.0
10-Nov-08 194.7 359.0 21.7
11-Nov-08 200.4 389.1 21.2
12-Nov-08 198.3 373.3 19.7
13-Nov-08 178.1 346.1 27.6
14-Nov-08 115.6 287.3 20.1
15-Nov-08 185.4 333.3 19.1
16-Nov-08 219.2 372.5 16.5
17-Nov-08 233.7 367.6 0.0
18-Nov-08 174.7 339.5 0.0
19-Nov-08 49.0 63.0 0.0
20-Nov-08 190.7 446.5 0.0
21-Nov-08 188.4 586.1 20.6
22-Nov-08 187.0 475.4 15.9
23-Nov-08 196.2 432.7 14.0
24-Nov-08 224.8 435.3 15.8
25-Nov-08 211.3 461.2 11.9
26-Nov-08 236.3 572.4 7.2
27-Nov-08 254.0 645.9 0.0
28-Nov-08 248.6 581.8 0.0
29-Nov-08 247.3 469.1 0.0
30-Nov-08 235.5 508.6 0.0
01-Dec-08 234.9 473.7 7.8
02-Dec-08 229.6 499.6 0.0
03-Dec-08 196.7 333.9 0.0
04-Dec-08 212.2 464.5 0.0
05-Dec-08 189.4 410.0 15.1
06-Dec-08 202.8 371.0 0.0
07-Dec-08 219.1 396.9 0.0
08-Dec-08 217.6 400.2 16.0
09-Dec-08 218.7 374.0 8.2
10-Dec-08 182.2 344.8 16.2
11-Dec-08 207.4 427.3 0.0
12-Dec-08 182.8 411.2 0.0
13-Dec-08 233.7 417.0 9.9
14-Dec-08 233.5 455.4 3.0
15-Dec-08 206.1 493.5 12.3
16-Dec-08 205.6 464.4 14.2
17-Dec-08 203.0 429.4 18.7
18-Dec-08 202.6 443.3 6.6
19-Dec-08 203.8 416.5 0.0
20-Dec-08 203.0 430.5 9.9
21-Dec-08 208.0 396.9 16.8
22-Dec-08 223.1 405.3 14.1
23-Dec-08 211.1 356.7 12.9
24-Dec-08 236.2 436.0 10.8
25-Dec-08 232.2 485.3 0.0
26-Dec-08 239.4 516.5 0.0
27-Dec-08 248.0 517.6 18.7
28-Dec-08 250.2 497.8 12.7
29-Dec-08 241.2 465.2 11.9
30-Dec-08 249.5 492.3 13.7
31-Dec-08 246.7 492.1 4.0


Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

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
Unable to sort when column is included in range Trudy Excel Discussion (Misc queries) 1 July 8th 08 03:27 PM
I'm building a stacked line chart. Ron Charts and Charting in Excel 1 January 23rd 08 08:49 PM
Building 3 axis chart. Erol Pekuz Charts and Charting in Excel 3 November 4th 07 08:25 PM
Range of variables with the 'floor' command included ReelDesigner Excel Worksheet Functions 0 January 26th 06 04:05 PM
Possible to chart data for dates implicit within a range? Nechama Charts and Charting in Excel 1 September 1st 05 10:11 PM


All times are GMT +1. The time now is 05:32 AM.

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

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement