Home > Articles > Home & Office Computing > Microsoft Applications

This chapter is from the book

This chapter is from the book

Inserting and Creating a Chart

A chart provides a visual, graphical representation of numerical data. Charts add visual interest and useful information represented by lines, bars, pie slices, or other markers. A group of data values from a worksheet row or column of data makes up a data series. Each data series has a unique color or pattern on the chart. Titles on the chart, horizontal (x-axis), and vertical (y-axis) identify the data. Gridlines are horizontal and vertical lines to help the reader determine data values in a chart. When you choose to place the chart on an existing sheet, rather than on a new sheet, the chart is called an embedded object. You can then resize or move it just as you would any graphic object. Office 2008 programs now use Microsoft Excel (New!) to embed and display a chart instead of Microsoft Graph.

Insert and Create a Chart

  • yellow-circle-01.gif Select the data you want to use to create a chart (Excel).
  • yellow-circle-02.gif Click the Charts tab on the Elements Gallery.
  • yellow-circle-03.gif Click one of the tabs (All, Area, Bar, Bubble, Column, Doughnut, Line, Pie, Radar, Stock, Surface, X Y (Scatter)) to display the type of Chart style you want.
  • yellow-circle-04.gif Click one of the Chart styles.

    • You can click the arrows on the right to display more styles.

      Microsoft Excel opens (from Word or PowerPoint), displaying sample data, which you can change.

  • yellow-circle-05.gif Use Excel commands to import or enter the chart data you want.

  • yellow-circle-06.gif If you inserted the chart from Word or PowerPoint, switch back.

    • A chart appears on the document as an embedded chart.
  • yellow-circle-07.gif To delete the chart, select it, and then press Delete.
  • yellow-circle-08.gif To create a chart sheet (Excel), click the Insert menu, point to Sheet, and then click Chart Sheet.
  • + Share This
  • 🔖 Save To Your Account