If you get your spreadsheet in order from yesterday’s directions, then here is your next challenge. See if you can create the following graphs of your data:
- A double-bar graph to compare the initial value of each stock to the final value of each stock on April 23rd.
- A pie chart to show how much of your total portfolio each stock represents
- A pie chart which includes how your stocks are spread across each capitalization and how much was left as cash.
Extra credit: add three more columns to your spreadsheet for each of the three major sectors. See if you can create a pie chart to show how your stocks are diversified across each sector.