Working with Charts - Exercise

Contact Us or call 1-877-932-8228
Working with Charts - Exercise

Working with Charts

Duration: 15 to 25 minutes.

In this exercise, you will copy a chart from an Excel file and use chart tools to modify the design and layout of the chart in Microsoft PowerPoint.

  1. Locate and open the PowerPoint file named "My Chart" in your Webucator/PowerPoint2013.1/Exercises folder.
  2. Locate and open the Excel file named "Business" in your Webucator/PowerPoint2013.1/Exercises folder.
  3. Copy the chart from Excel into the slide titled "Commission Chart". Ensure that the Link option is checked.
  4. Change the chart style to Style 42. (If you are using PowerPoint 2007 or 2010, choose a style with a black background.)
  5. Save the PowerPoint file "My Chart" for future use.
  6. Close the Excel file "Business" without saving any changes.

Solution:

  1. Locate and open the PowerPoint file named "My Chart" in your Webucator/PowerPoint2013.1/Exercises folder.
  2. Locate and open the Excel file named "Business" in your Webucator/PowerPoint2013.1/Exercises folder. Ensure that the Link option is checked. Note: If linked files are moved, the link may be broken, requiring you to reinsert the chart.
  3. Copy the chart from Excel into the slide titled "Commission Chart".
    1. In Excel, select the chart and press Ctrl + C to copy the chart to the clipboard.
    2. In your PowerPoint presentation, select the slide titled "Commission Chart" to copy the chart to and press Ctrl + V to paste the chart from the clipboard to your slide. You may need to drag the sizing handles to adjust the size of the chart.
  4. Change the style of the chart to Style 8. (If you are using PowerPoint 2007 or 2010, choose a style with a black background.)
    1. Select the chart in your presentation.
    2. On the CHART TOOLS DESIGN tab, in the Chart Styles group, click the More down arrow to open the chart style gallery, and select Style 42.
  5. Save the PowerPoint file with the name "My Chart".
  6. Close the Excel file "Business" without saving any changes.
Next