Since we have the daily index and the graph will be

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: the DJIA. Since we have the daily index and the graph will be shrunk, we only wanted the years to be shown. To show only the years, we right-clicked on the X-axis numbers, selected Format Axis, Number, selected the Custom option, and entered "yyyy" as the custom format. To get the year to show only once is somewhat trickier. Excel uses serial dates. January 1, 1900 is 1, January 2, 1900 is 2, and so on. On the Axis Options, we needed to get 2003 to display at the X-Y intersection for December 31, 2003, 2008 to display at the end of the X-axis, and each year to display only once. To do this, we needed the serial date for these dates. To find the serial date, we simply entered 12/31/2003 in a cell, right-clicked the cell, and changed the display to Number. This changes the MM/DD/YY display into the serial date. Once we had the serial dates we needed, we set the minimum X-axis at 37986 (the serial date for 12/31/2003) and the maximum X-axis at 39813 (the serial date for 12/31/2008). We used 365 as the major unit to display, which increased the serial data by exactly one year. This is what allows only one of each year to display on the X-axis. We realize that the year is actually off 1 day because of leap year. Given that we are not concerned with the fine detail of these graphs, this is not a problem. Finally, we needed to resize the graph. To do this, we selected the entire graph, which brings up the Chart Tools tabs. We went to the Format tab and resized the graph using the Size options. To graph the other indices, we could have completed the same process for each graph. Instead, we copied and pasted the first graph. We then clicked the data line, chose Select Data, then edited the data series by changing the columns being graphed. D JIA 12/31/2003 1/2/2004 1/5/2004 1/6/2004 1/7/2004 1/8/2004 1/9/2004 1/12/2004 1/13/2004 1/14/2004 1/15/2004 1/16/2004 1/20/2004 1/21/2004 1/22/2004 1/23/2004 1/26/2004 1/27/2004 1/28/2004 1/29/2004 1/30/2004 2/2/2004 2/3/2004 2/4/2004 2/5/2004 2/6/2004 2/9/2004 2/10/2004 2/11/2004 2/12/2004 2/13/2004 2/17/2004 2/18/2004 2/19/2004 2/20/2004 2/23/2004 2/24/2004 2/25/2004 2/26/2004 2/27/2004 3/1/2004 3/2/2004 3/3/2004 3/4/2004 3/5/2004 3/8/2004 3/9/2004 3/10/2004 3/11/2004 3/12/2004 3/15/2004 3/16/2004 3/17/2004 3/18/2004 3/19/2004 3/22/2004 3/23/2004 3/24/2004 3/25/2004 3/26/2004 3/29/2004 3/30/2004 3/31/2004 4/1/2004 4/2/2004 4/5/2004 4/6/2004 4/7/2004 4/8/2004 4/12/2004 4/13/2004 4/14/2004 4/15/2004 4/16/2004 4/19/2004 4/20/2004 4/21/2004 4/22/2004 4/23/2004 4/26/2004 4/27/2004 4/28/2004 4/29/2004 4/30/2004 5/3/2004 5/4/2004 5/5/2004 5/6/2004 5/7/2004 5/10/2004 5/11/2004 5/12/2004 5/13/2004 5/14/2004 5/17/2004 5/18/2004 5/19/2004 5/20/2004 5/21/2004 5/24/2004 5/25/2004 5/26/2004 5/27/2004 5/28/2004 6/1/2004 6/2/2004 6/3/2004 6/4/2004 6/7/2004 6/8/2004 6/9/2004 6/10/2004 6/14/2004 6/15/2004 6/16/2004 6/17/2004 6/18/2004 6/21/2004 6/22/2004 6/23/2004 6/24/2004 6/25/2004 6/28/2004 6/29/2004 6/30/2004 7/1/2004 7/2/2004 7/6/2004 7/7/2004 7/8/2004 7/9/2004 7/12/2004 7/13/2004 7/14/2004 7/15/2004 7/16/2004 7/19/2004 7/20/2004 7/21/2004 7/22/2004 7/23/2004 7/26/2004 7/27/2004 7/28/2004 7/29/2004 7/30/2004 8/2/2004 8/3/2004 8/4/2004 8/5/2004 8/6/2004 8/9/2004 8/10/2004 8/11/2004 8/12/2004 8/13/2004 8/16/2004 8/17/2004 8/18/2004 8/19/2004 8/20/2004 8/23/2004 8/24/2004 8/25/2004 8/26/2004 8/27/2004 8/30/2004 8/31/2004 9/1/2004 9/2/2004 9/3/2004 9/7/2004 9/8/2004 9/9/2004 9/10/2004 9/13/2004 9/14/2004 9/15/2004 9/16/2004 9/17/2004 9/20/2004 9/21/2004 9/22/2004 9/23/2004 9/24/2004 9/27/2004 9/28/2004 9/29/2004 9/30/2004 10/1/2004 10/4/2004 10/5/2004 10/6/2004 10/7/2004 10/8/2004 10/11/2004 10/12/2004 10/13/2004 10/14/2004 10/15/2004 10/18/2004 10/19/2004 10/20/2004 10/21/2004 10/22/2004 10/25/2004 10/26/2004 10/27/2004 10/28/2004 10/29/2004 11/1/2004 11/2/2004 11/3/2004 11/4/2004 11/5/2004 11/8/2004 11/9/2004 11/10/2004 11/11/2004 11/12/2004 11/15/2004 11/16/2004 11/17/2004 11/18/2004 11/19/2004 11/22/2004 11/23/2004 11/24/2004 11/26/2004 11/29/2004 11/30/2004 12/1/2004 12/2/2004 12/3/2004 12/6/2004 12/7/2004 12/8/2004 12/9/2004 12/10/2004 12/13/2004 12/14/2004 12/15/2004 12/16/2004 12/17/2004 12/20/2004 12/21/2004 12/22/2004 12/23/2004 12/27/2004 12/28/2004 12/29/2004 12/30/2004 12/31/2004 1/3/2005 1/4/2005 1/5/2005 1/6/2005 1/7/2005 1/10/2005 1/11/2005 1/12/2005 1/13/2005 1/14/2005 1/18/2005 1/19/2005 1/20/2005 1/21/2005 1/24/2005 1/25/2005 1/26/2005 1/27/2005 1/28/2005 1/31/2005 2/1/2005 2/2/2005 2/3/2005 2/4/2005 2/7/2005 2/8/2005 2/9/2005 2/10/2005 2/11/2005 2/14/2005 2/15/2005 2/16/2005 2/17/2005 2/18/2005 2/22/2005 2/23/2005 2/24/2005 2/25/2005 2/28/2005 3/1/2005 3/2/2005 3/3/2005 3/4/2005 3/7/2005 3/8/2005 3/9/2005 3/10/2005 3/11/2005 3/14/2005 3/15/2005 3/16/2005 3/17/2005 3/18/2005 3/21/2005 3/22/2005 3/23/2005 3/24/2005 3/28/2005 3/29/2005 3/30/2005 3/31/2005 4/1/2005 4/4/2005 4/5/2005 4/6/2005 4/7/2005 4/8/2005 4/11/2005 4/12/2005 4/13/2005 4/14/2005 4/15/2005 4/18/20...
View Full Document

This document was uploaded on 02/08/2014.

Ask a homework question - tutors are online