3.2 Inserting graphs

In this exercise you will create the business flyer shown below.

1. Open the data file downloaded from the above link. It contains the text for the document.
2. Create a company logo using WordArt or styles at the top of the document.
3. Place the cursor after the second paragraph.
4. If you are using Microsoft Word:

   

   1. Use the CHART icon from the INSERT tab of the ribbon to start the chart and select the COLUMN chart option. A Microsoft Excel DATA pane will open.
   2. Enter the values shown in the diagram and drag the bottom right handle to enclose the entries.
   3. Close the DATA pane, set the LAYOUT OPTIONS icon to set the TEXT WRAPPING to TOP AND BOTTOM so that the text is placed above and below the chart.
   4. Format the chart. You can use the CHART STYLES in the ribbon or format each section of the chart by selecting its individual sections in turn.
5. If you are using Google Docs, the chart needs to be created in Google sheets.

   

   1. Open Google Sheets, start a new document, enter the data and highlight it.
   2. Select CHART from the Insert menu, select a chart from the RECOMMENDATIONS tab then open the CUSTOMISATION tab.
   3. Enter a CHART TITLE, add a BACKGROUND, turn off the LEGEND and, in the AXIS HORIZONTAL section, turn on TREAT LABELS AS TEXT so that the years are displayed correctly.
   4. Select INSERT to complete the chart then save it as an image using the down arrow at the top right of the chart.
   5. Open your Google Docs file and insert the image from your Downloads folder.
6. Once the flyer is complete, save it, spell check it and proofread it. Once corrections have been made, print a final copy or share your work electronically.