formatting charts

Excel 2007Objective 4: Presenting Data Visually

Lesson Skills By the end of the lesson you should be

familiar with how-to: Insert and delete chart elements such as

titles, legends, percentages, etc. Move a chart to a different location, and Change between chart types

Inserting and Deleting Chart Elements Chart Axis TitleChart TitleChart Legend

Titles Titles make a chart easier to understand

by providing the viewer labels that define the data represented.

Go here to access more information about chart titles

Legends Legends are boxes that identify the

patterns or colors that are assigned to the data series or categories in a chart.

To read more about how-to insert legends, go HERE

Other Elements More elements, such as data labels and

trendlines, can be added by going to the Chart Tools Layout tab

Moving a Chart

Moving a Chart By default, a chart is created on the

worksheet that is active You can choose to move a chart to

another worksheet or workbook.

Moving a Chart1. Go to your Chart Tools

Design tab and click the Move Chart button

2. Select either New Sheet to move the chart to its own worksheet in the workbook, or

3. Select Object in to move the chart to another worksheet

Changing Chart Types You can elect to switch between

different chart types as needed. Go HERE for more information on how-to

switch

Practice Activity Open your workbook from the first

presentation Practice adding, removing and

modifying titles, legends and other elements on the chart

Practice moving the chart to different locations

Practice changing chart types