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 add a chart to a document and then edit the design and layout of the chart.

  1. Open or go to Plants in my yard - Intermediate.docx.
  2. Insert a chart at the end of the document that looks like the one shown below (the data labels are listed below the image for easier reading):Chart
    1. Attracts Butterflies
    2. Deer Resistant
    3. Drought Tolerant
    4. Attracts Hummingbirds
    5. Cooler than other flowers
    6. Beautiful foliage
  3. Save your document.

Solution:

  1. Place your cursor on a new line at the end of the document.
  2. From the INSERT tab, in the Illustrations group, click Chart: Chart in Illustrations Group of Insert Tab
  3. Select the 3-D Stacked Column chart (in Word 2007/2010, Stacked Column in 3-D) and click OK: Insert Chart Dialog Box
  4. Edit the data in Microsoft Excel as follows:
    1. Delete columns C and D by selecting the columns, and then right-clicking. Chart
    2. Click Delete and then select Table Columns (in Word 2007/2010, just click Delete).Delete Table Columns
    3. Add two rows to the data range by dragging the lower right corner of the range down: Lower Right Corner of Range
    4. Click OK to the message box that appears: Message Box
    5. Type in the six attributes and the corresponding counts in cells A2:B7. Then type "Count of Attributes" in cell B1: Chart with Attributes
    6. Select the chart by clicking on it. Click the plus sign to the right of the chart. In the CHART ELEMENTS box, scroll to and uncheck the Legend checkbox. Legend Check Box
    7. Select the chart columns by clicking on one of them. On the CHART TOOLS FORMAT tab, click Shape Fill and then select Red: Shape Fill Colors
    8. Save the file.

In Word 2007/2010, to turn the data labels on, on the CHART TOOLS LAYOUT tab, click Data Labels and then click Show. To turn the legend off, on the Chart Tools > Layout tab, click Legend and then click None.

Next