Excel Tutorial 4

(1)

COMPREHENSIVE

Excel Tutorial 4

(2)

XP XP

Objectives

• _{Create an embedded chart}

• _{Work with chart titles and legends} • _{Create and format a pie chart}

• _{Work with 3D charts}

• _{Create and format a column chart}

(3)

XP XP

Objectives

• _{Create and format a line chart}

• _{Use custom formatting with chart axes} • _{Work with tick marks and scale values} • _{Create and format a combined chart} • _{Insert and format a graphic shape}

• _{Create a chart sheet}

(4)

XP XP

Creating Charts

• _A_chart_{, or}_graph_{, is a visual representation of a set of}

data

• _{Select the data source with the range of data you want}

to chart

• _{In the Charts group on the Insert tab, click a chart type,}

and then click a chart subtype in the Chart gallery

• _{In the Location group on the Chart Tools Design tab,}

click the Move Chart button to place the chart in a chart sheet or embed it into a worksheet

(5)

XP XP

Creating Charts

(6)

XP XP

Selecting a Data Source

• _The_{data source}_{is the range that contains the} data you want to display in the chart

– _{Data series} – _{Series name} – _{Series values}

– _{Category values}

(7)

XP XP

Selecting a Chart Type

(8)

XP XP

Selecting a Chart Type

• _{Click the}_Insert_{tab on the Ribbon}

• _{In the Charts group, click the}_Pie_button

(9)

XP XP

Moving and Resizing Charts

• _{By default, a chart is inserted as an}_embedded

chart, which means the chart is placed in a worksheet next to its data source

• _{You can also place a chart in a}_{chart sheet}

• _{In the Location group on the Chart Tools Design} tab, click the Move Chart button

(10)

XP XP

Selecting Chart Elements

(11)

XP XP

Choosing a Chart Style and Layout

(12)

XP XP

Choosing a Chart Style and Layout

(13)

XP XP

Working with the Chart Title and

Legend

• _{Click the chart title to select it}

• _{Type the chart title, and then press the}_Enter_key • _{Click the}_{Chart Tools Layout}_{tab on the Ribbon} • _{In the Labels group, click the}_Legend_{button, and}

then click the desired legend position

(14)

XP XP

Working with the Chart Title and

Legend

(15)

XP XP

Formatting a Pie Chart

• _{Click the chart to select it}

• _{In the Labels group on the Chart Tools Layout} tab, click the Data Labels button, and then click

More Data Label Options

(16)

XP XP

Setting the Pie Slice Colors

• _{In pie charts with legends, it’s best to make the} slice colors as distinct as possible to avoid

confusion

• _{Click the pie to select the entire data series, and} then click the slice you wish to change

• _{Change the fill color}

(17)

XP XP

Working with 3D Options

• _{To increase the 3D effect, you need to rotate the} chart

• _{Click the}_{Chart Tools Layout}_{tab on the Ribbon,} and then, in the Background group, click the 3-D Rotation button

(18)

XP XP

Creating a Column Chart

• _A_{column chart}_{displays values in different}

categories as columns; the height of each column is based on its value

• _The_{bar chart}_{is a column chart turned on its} side, so each bar length is based on its value

(19)

XP XP

Creating a Column Chart

• _{Select the range}

• _{In the Charts group, click the}_Column_{button and} then choose the chart subtype

(20)

XP XP

Formatting Column Chart Elements

• _{Click the}_{Chart Tools Layout}_{tab on the Ribbon}

(21)

XP XP

Formatting the Chart Axes

(22)

XP XP

Formatting the Chart Axes

(23)

XP XP

Formatting Chart Columns

• _{Click any column in the Sector Weightings chart} • _{In the Current Selection group on the Chart Tools}

Layout tab, click Format Selection

(24)

XP XP

Formatting Chart Columns

(25)

XP XP

Creating a Line Chart

• _{Select the range}

• _{In the Charts group, click the}_Line_{button, and} then click the Line chart

(26)

XP XP

Formatting Date Labels

• _{In the Axes group, click the}_Axes_{button, point to}

Primary Horizontal Axis, and then click More Primary Horizontal Axis Options

(27)

XP XP

Formatting Date Labels

(28)

XP XP

Setting Label Units

• _{In the Axes group on the Chart Tools Layout tab,} click the Axes button, point to Primary Vertical Axis, and then click More Primary Vertical Axis Options

• _{Click the}_{Display units}_{arrow and then make your} selection

(29)

XP XP

Setting Label Units

(30)

XP XP

Overlaying a Legend

• _{In the Labels group on the Chart Tools Layout}

tab, click the Legend button, and then click More Legend Options

• _{Click the}_{Show the legend without overlapping}

the chart check box to remove the check mark

(31)

XP XP

Adding a Data Series

to an Existing Chart

• _{Select the chart to which you want to add a data} series

• _{In the Data group on the Chart Tools Design tab,} click the Select Data button

• _{Click the Add button in the Select Data Source dialog} box

• _{Select the range with the series name and series} values you want for the new data series

• _{Click the OK button in each dialog box}

(32)

XP XP

Adding a Data Series

to an Existing Chart

(33)

XP XP

Creating a Combination Chart

• _{Select a data series in an existing chart that you} want to appear as another chart type

• _{In the Type group on the Chart Tools Design tab,} click the Change Chart Type button, and then

click the chart type you want • _{Click the OK button}

(34)

XP XP

Creating a Combination Chart

(35)

XP XP

Inserting a Shape

• _{In the Illustrations group, click the}_Shapes button, and then choose the shape you want • _{Draw the shape in your worksheet}

(36)

XP XP

Aligning and Grouping Shapes

• _{Hold down the}_Shift_{key and then click each} shape to select it

• _{Click the}_{Drawing Tools Format}_{tab on the} Ribbon

• _{In the Arrange group, click the}_Align_{button, and} then click your alignment option

• _{To group several shapes into a single unit, select} the shapes, and then click the Group button in the Arrange group on the Drawing Tools Format tab

(37)

XP XP