Free Microsoft Office Tutorials | Online Office Learning Guide | Microsoft Office Tips and Tricks

Charts allow you to present information contained in the worksheet in a graphic format. Excel offers many types of charts including: Column, Line, Pie, Bar, Area, Scatter and more. To view the charts available click the Insert Tab on the Ribbon.

Create a Chart
To create a chart:

• Select the cells that contain the data you want to use in the chart
• Click the Insert tab on the Ribbon
• Click the type of Chart you want to create

Modify a Chart
Once you have created a chart you can do several things to modify the chart.

To move the chart:

• Click the Chart and Drag it another location on the same worksheet, or
• Click the Move Chart button on the Design tab
• Choose the desired location (either a new sheet or a current sheet in the workbook)

To change the data included in the chart:

• Click the Chart
• Click the Select Data button on the Design tab

To reverse which data are displayed in the rows and columns:

• Click the Chart
• Click the Switch Row/Column button on the Design tab

To modify the labels and titles:

• Click the Chart
• On the Layout tab, click the Chart Title or the Data Labels button
• Change the Title and click Enter

Chart Tools
The Chart Tools appear on the Ribbon when you click on the chart. The tools are located on three tabs: Design, Layout, and Format.

Within the Design tab you can control the chart type, layout, styles, and location.

Within the Layout tab you can control inserting pictures, shapes and text boxes, labels, axes, background, and analysis.

Within the Format tab you can modify shape styles, word styles and size of the chart.

Copy a Chart to Word

• Select the chart
• Click Copy on the Home tab
• Go to the Word document where you want the chart located
• Click Paste on the Home tab

Popularity: 4% [?]

The easiest way to create a Table of Contents is to utilize the Heading Styles that you want to include in the Table of Contents. For example: Heading 1, Heading 2, etc. based on the content of your document. When you add or delete headings from your document, Word updates your Table of Contents. Word also updates the page number in the table of contents when information in the document is added or deleted. When you create a Table of Contents, the first thing you want to do is mark the entries in your document. The Table of Contents is formatted based on levels of headings. Level 1 will include any text identified with the style Heading 1.

Mark Table of Contents Entries
You can mark the Table of Contents entries in one of two ways: by using built-in heading styles or by marking individual text entries.

To Use Built-In Heading Styles

• Select the text that you wish to be the heading
• Click the Home Tab
• In the Styles Group, click Heading 1 (or the appropriate heading)

• If you don’t see the style you want, click the arrow to expand the Quick Styles Gallery
• If the style you want does not appear click Save Selection as New Quick Style

To Mark Individual Entries:

• Select the text you wish to make a heading
• Click the References Tab
• Click Add Text in the Table of Contents Group
• Click the Level that you want to label your selection

Create a Table of Contents
To create the table of contents:

• Put your cursor in the document where you want the Table of Contents
• Click the References Tab
• Click the Table of Contents button

Update Table of Contents
If you have added or removed headings or other table of contents entries you can update by:

• Apply headings or mark individual entries as directed above
• Click the References Tab in the Ribbon
• Click Update Table

Delete Table of Contents
To delete a table of contents:

• Click the References Tab on the Ribbon
• Click Table of Contents
• Click Remove Table of Contents

Popularity: 12% [?]