Finally we want to compare the performance of these two stocks over the last year.

• On the S & P 500 page starting in cell H27 and ending in cell P50 create a Combination line chart to compare the change in closing stock price for each of these two securities for the dates during the entire last 12 months (9/15/2022 - 9/14/2023). The reason that we need this chart to be a combination line chart is because the two ranges of closing prices of the stocks are considerably different. Over the past year S & P 500 varied from ~$3,600 - $4,600 while Apple varied between ~125 - 200. If we plot those using the same scale the chart will not show the entire picture/comparison since we want to overlay them on top of each other.
• For full credit your chart should refer to the data on the existing S&P500 and Apple sheets containing all of the original data (the entire year's worth) for each of the two stocks. For some reason some students will take the incorrect approach of copying the closing prices of the 2 securities onto the same sheet and then creating the needed chart from this data. This is less than ideal since they would be making copies of the data and this redundancy can lead to incorrect data/charts if the original data is updated but this copied data is not!
• Since the price of S & P 500 mutual fund varies 3,600 - 4,600 your left hand vertical axis values should be from 3,300 - 4,800. To have the Apple stock prices lay approximately accurately (so that their two % increases are accurately reflected on the chart) on top of the S & P 500 prices, alter the values on the right hand axis of your combo chart to a minimum of 100 and a maximum of 240. Format the numbers in both of the vertical axes as you did in the previous 2 steps with comma separators for the thousands and 12 pt font.
• Which stock performed better over the past year? To find the answer to this question, add linear trendlines to both the S & P 500 & Apple series. In a cell immediately to the right of this chart tell us which stock has the better trendline as far as which one is more positive of a slope than the other?
• Add the title of Stock Comparison to the top of the chart.
• Add a legend to the bottom of the chart.
• Make sure each Series Name is set to cell $A$1 (on the appropriate S & P 500/Apple worksheet) as opposed to "hard-coding" the name of the series into the chart. In case you didn't watch the video titled "Charting Across Multiple Sheets" on the Module 3 Overview sheet you can get access to this in the Select Data icon on the Chart Design ribbon.