Follow the instructions below to complete the worksheet
Open the workbook named Invest.xlsx
Create a chart for each company using the appropriate stock-chart sub-type. Be certain to use each chart sub-type only once.
Summarize the data to clearly show some of the data markers in the charts.
Place each chart on a new sheet in the workbook.
Use the appropriate chart to compare the change in stock price for each company over the last year.
Using the information on the portfolio worksheet, prepare the appropriate chart to display the relative contribution of each stock to the value of the portfolio.