[Solved] Module 04 course project-enhancing your portfolio with themes, illustrations and charts

Module 04 course project-enhancing your portfolio with themes, illustrations and charts

In the two project pieces you created the core of the portfolio and filed in the initial purchase data (e.g., number of stocks purchased, purchase price, date of purchase, total investment) of 10 different stocks. You also performed several different tasks. It is now time to enhance your workbook with a theme, illustration, and pie chart.

For this piece of the project, include the following in your portfolio (separate worksheets if applicable):

1. Create a pie chart of the stocks you purchased using the “Ticker Symbol” and “# of shares purchased” columns
2. Move the chart to a separate sheet
3. Name the sheet “Portfolio Pie Chart”
4. Add a relevant chart title and any other elements to make the chart easy to interpret
5. Create a column chart using the “Ticker Symbol” column and two other additional non-contiguous columns
6. Move the chart to a separate sheet
7. Name the sheet “ Portfolio Column Chart”
8. Add the relevant chart title and any other elements to make the chart easy to interpret
9. Pictures add to the visual appeal of the charts. On the portfolio sheet, insert a small relevant picture from the internet into your workbook =in an appropriate spot of your choice. Do not block the data. Resize if necessary. For more information on inserting an online picture, follow this
10. In the ribbon, under the page layout tab, click on the thumbnail of the new theme you want to apply to the worksheet (e.g. Organic, Wisp, Integral, etc.) note that the theme might change the colour of the chart.

Expert Answer

---

Answer to Module 04 course project-enhancing your portfolio with themes, illustrations and charts….