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

Using Excel 2003
 

The simple methopd is just to put two vertine lines on the graph manually.

Add the drawing toolbar into your workbook using the menu

Insert - Toolbars - Drawing

Then add a line like you would in any drawings. Make a vertical line at the
start date and a 2nd line at the end date.

"Sarah_Lecturer" wrote:

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