Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 attachments open and show only empty cells when openedvia Outlook 2003? | Excel Discussion (Misc queries) | |||
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |