Home > Articles

This chapter is from the book

This chapter is from the book

Inserting and Creating a Chart

EX07S-4.1.1, EX07S-4.1.2, EX07S-4.2.2, PP07S-3.6.1

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.

Insert and Create a Chart

yellow_circle_1.gif Select the data you want to use to create a chart.

yellow_circle_2.gif Click the Insert tab.

yellow_circle_3.gif Use one of the following methods:

  • Basic Chart Types. Click a chart button (Column, Line, Pie, Bar, Area, Scatter, Other Charts) in the Charts group, and then click the chart type you want.

  • All Chart Types. Click the Charts Dialog Box Launcher, click a category in the left pane, click a chart, and then click OK.

A chart appears on the document as an embedded chart.

  • + Share This
  • 🔖 Save To Your Account