- Locating and Inserting Clip Art
- Inserting a Picture
- Adding a Quick Style to a Picture
- Applying a Shape to a Picture
- Applying a Border to a Picture
- Applying Picture Effects
- Modifying Picture Size
- Compressing a Picture
- Modifying Picture Brightness and Contrast
- Recoloring a Picture
- Cropping and Rotating a Picture
- Scanning and Imaging Documents
- Managing Pictures
- Creating WordArt Text
- Formatting WordArt Text
- Applying WordArt Text Effects
- Modifying WordArt Text Position
- Creating SmartArt Graphics
- Formatting a SmartArt Graphic
- Modifying a SmartArt Graphic
- Creating an Organization Chart
- Modifying an Organization Chart
- Inserting and Creating a Chart
- Changing a Chart Type
- Changing a Chart Layout and Style
- Changing Chart Titles
- Changing Chart Labels
- Formatting Line and Bar Charts
- Editing Chart Data
- Saving a Chart Template
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
Select the data you want to use to create a chart.
Click the Insert tab.
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.