View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sarah_Lecturer Sarah_Lecturer is offline
external usenet poster
 
Posts: 18
Default Using Excel 2003

Hi

I would like to plot along the x axis the date (currently in cell the first
column of the table below) and then mark the prices of the three categories
on the top row of the table by line graph. However I want to include in the x
axis scale all the date and price entries but only mark out the dates in bold
in the first column

Also, if it can be done, I want to isolate the line graph by section so that
it tracks the price the week before, the week of the bold date and the week
after and then breaks until the next set of three dates.

Thanks for all your help







Date VAA BA CX

03/02/2003 616 616 649
19/02/2003 616 616 649
24/02/2003 616 616 649
17/03/2003 616 616 649
27/03/2003 621 621 649
31/03/2003 621 621 649
02/04/2003 621 621 649
07/04/2003 621 621 649
06/05/2003 621 621 649
16/05/2003 621 621 649
19/05/2003 621 621 649
29/05/2003 621 621 649
02/06/2003 621 621 649
16/08/2003 626 626 668