Creating Charts from Your Data

1
Creating Charts from Your Data

• Lesson 8

2

• SKILL MATRIX SKILL
• Build charts
• Manually format the parts of a chart
• Modify a chart

Skills Matrix
3

• SKILL MATRIX SKILL
• 4.1.1 Select appropriate data sources for charts
• 4.1.2 Select appropriate chart types to represent
  data sources
• 4.1.3 Format charts using Quick Styles

Skills Matrix
4

• SKILL MATRIX SKILL
• 4.2.1 Add and remove chart elements
• 4.2.2 Move and size charts
• 4.2.3 Change chart types

Skills Matrix
5
Insert Tab
Click a chart type to create a chart
Five additional chart types can be created here
Charts Dialog Box Launcher
Software Orientation
6
Charts

• Chart Graphical representation of numeric data
• Excel allows charts to be modified in many ways

• Layout
• Style

Software Orientation
7
Select Data to Include in a Chart

• Charts allow you to
• Summarize and highlight data
• Reveal trends
• Make comparisons

Building Charts
8
Select Data to Include in a Chart (cont.)

• Select range of data
• Insert tab, Charts group, type of chart

Building Charts
9
Select Data to Include in a Chart (cont.)
Selected data used to generate pie chart
Building Charts
10
Choose the Right Chart for Your Data

• Each type of chart well-suited for particular
  situations
• Pie chart cannot be used for comparison across
  time
• Column and line charts can provide two views of
  same data

Building Charts
11
Choose the Right Chart for Your Data (cont.)
Chart Types
Building Charts
12
Choose the Right Chart for Your Data (cont.)
Chart Types (cont.)
Building Charts
13
Choose the Right Chart for Your Data (cont.)
Chart Types (cont.)
Building Charts
14
Choose the Right Chart for Your Data (cont.)
Chart Types (cont.)
Building Charts
15
Choose the Right Chart for Your Data (cont.)
Components of Line Chart
Data markers
Data series
Building Charts
16
Create a Bar Chart

• Clustered bar charts
• Compare values across categories

• Stacked bar charts
• Show relationship of individual items to whole

Building Charts
17
Create a Bar Chart (cont.)

• Select range of data to use
• Insert tab, Charts group, Bar
• Select bar subtype
• Position chart on worksheet

Building Charts
18
Create a Bar Chart (cont.)
Select chart type from this pane
Select subtype for bar charts from this pane
Building Charts
19
Format a Chart with a Quick Style

• Quick Style Predefined layouts and styles
• When chart selected, Ribbon changes

Chart tools automatically displayed with three
tabs when chart selected
Formatting a Chart with a Quick Style
20
Format a Chart with a Quick Style (cont.)

• Design tab, Chart Layouts group
• Select desired layout
• Select desired style

Formatting a Chart with a Quick Style
21
Format a Chart with a Quick Style (cont.)
Style 4 applied to chart
Layout 1 applied to chart
Formatting a Chart with a Quick Style
22
Chart Elements

• Chart area Entire chart and all its elements
• Plot area Area bounded by axes
• Axis Line bordering chart plot area

Manually Formatting Parts of a Chart
23
Chart Elements (cont.)

• Title Descriptive text aligned to an axis or
  centered at top of chart
• Data labels Text providing additional
  information about data marker
• Legend Box identifying patterns or colors

Manually Formatting Parts of a Chart
24
Chart Elements (cont.)
Legend keys
Chart title
Vertical axis
Legend
Data labels
Walls
Chart area selected
Manually Formatting Parts of a Chart
25
Change the Charts Fill Color or Pattern
Color options
Manually Formatting Parts of a Chart
26
Change the Charts Fill Color or Pattern (cont.)
Texture options
Manually Formatting Parts of a Chart
27
Change the Charts Fill Color or Pattern (cont.)

• Click arrow next to Chart Elements in Current
  Selection group on Format tab
• List of chart elements appears

Select chart element you wish to format
Manually Formatting Parts of a Chart
28
Format Tab with Chart Tools
Add color, texture, and gradient
Click arrow to select element to format
Add special effects, such as shadows or bevel
Predefined outlines
More predefined outlines and shading
Manually Formatting Parts of a Chart
29
Change the Charts Border Line

• Can place border around entire chart or any
  element
• Can use colored outlines in Shape Styles group
• OR
• Click Shape Outline, choose Theme or Standard
  color

Manually Formatting Parts of a Chart
30
Format the Data Series

• Formatting data series
• Apply fill color to data series
• Place border around data series
• Add special effects to columns, bars, and so on

Manually Formatting Parts of a Chart
31
Modify a Charts Legend

• Modifying chart legend
• Expand or collapse legend box
• Edit text in legend
• Change character attributes

Manually Formatting Parts of a Chart
32
Add Elements to a Chart

• Go to Layout tab
• Click item to add

Modifying a Chart
33
Delete Elements from a Chart

• Click element on Layout tab, click None
• OR
• Select element, press Delete key
• OR
• Select element in Current Selection group, press
  Delete key

Modifying a Chart
34
Move a Chart

• Click blank area of chart and drag chart to new
  location
• OR
• Design tab, Location group, Move Chart
• Enter new location in Move Chart dialog box,
  click OK

Modifying a Chart
35
Resize a Chart

• Drag sizing handles to resize chart
• OR
• Go to Format tab
• Click Shape Height arrows to change height
• Click Shape Width arrows to change width

Shape Height
Shape Width
Modifying a Chart
36
Choose a Different Chart Type

• Select chart
• Design tab, Type group, Change Chart Type
• Select new chart type
• Click OK

Modifying a Chart
37
You Learned How to

• Build charts that summarize and highlight
  significant data
• Select suitable data to include in a chart
• Choose the best chart type to display the data

Summary
38
You Learned How to (cont.)

• Change the appearance of a chart by applying a
  Quick Style
• Modify and format parts of a chart
• Modify and move elements of a chart
• Add elements to a chart

Summary
39
You Learned How to (cont.)

• Delete elements from a chart
• Move an embedded chart to a chart sheet
• Move and size an embedded chart
• Choose a different chart type to display selected
  data

Summary