microsoft office 2013: in practice chapter 3 creating and editing charts copyright © 2014 by the...
TRANSCRIPT
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
Microsoft Office 2013: In Practice
Chapter 3
Creating and Editing Charts
Copyright © 2014 by The McGraw-Hill Companies, Inc. All rights reserved.McGraw-Hill/Irwin
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-2
Student Learning Outcomes
• Designing a Chart with Quick Layouts and Styles
• Creating a Chart Object and a Chart Sheet3.1
3.2
• Editing a Chart3.3
• Formatting Chart Elements3.4
• Using Images, Shapes, and WordArt in a Chart3.5
• Creating and Editing a Pie Chart and a Combination Chart3.6
• Inserting Sparklines in a Worksheet3.7
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-3
Case Study
Paradise Lakes Resort (PLR) Vacation companyFour resort chainsIn northern Minnesota
Develop various charts for
monthly sales data!
Monitor the resort’s
business and formulate
goals for next year!
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-4
Creating a Chart Object and a Chart SheetSLO 3.1
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-5
Chart Object
Selectable object surrounded by a square border
Contains many customizable chart elements
Can be resized and repositioned in a worksheet
Made from source dataQuick Analysis can be
used to suggest commands
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-6
Chart Types
Column Bar Pie Line
AreaXY
Scatter or Bubble
Stock Surface
Radar Combo Chart
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-7
Size and Position Chart Objects
Use the eight selection handles
Resize with two-pointed arrows
Move with four-pointed arrows
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-8
Chart Sheet
Displayed on its own sheet in the workbook
Omits rows, columns, and cells
Linked to data on another worksheet
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-9
Designing a Chart with Quick Layouts and Styles
SLO 3.2
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-10
Designing a Chart
Quick Layout
• Chart Tools Design tab, Chart Layouts group, Quick Layout
Chart Style
• Chart Tools Design tab, Chart Styles group, Chart Style gallery
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-11
Print a Chart
Print with data or on a separate sheet
Size and position or scale to fitChoose landscape or portrait
orientationInsert headers or footers as
necessary
File tab, Backstage view,
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-12
Editing a Chart
SLO 3.3
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-13
Edit a Chart
Switch Row and Column Data
Add and Remove Chart Elements
Change Chart Type
Filter the Source Data
Edit a Chart Data Source
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-14
Chart Elements
Axis Axis title
Chart area
Chart floor
Chart title
Chart wall
Data label
Data marker
Data point
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-15
Formatting Chart Elements
SLO 3.4
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-16
Edit a Chart
Shape Styles
Shape Fill, Outline, and Effects
Format Task Pane
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-17
Using Images, Shapes, and WordArt in a ChartSLO 3.5
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-18
Graphics in Charts
Picture Shape Fill
Shapes
WordArt
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-19
Creating and Editing a Pie Chart and a Combination ChartSLO 3.6
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-20
3-D Pie Chart
Graph one data series, one set of numbers
Limit categories to size or seven
Illustrate relationship to a wholeSet % in the data label to
increase understanding of dataModify chart elements to
personalize Rotate for easy viewingExplode a slice to emphasize
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-21
Combination Chart
Includes two chart types Commonly line and column
combinedDisplays two sets of values, two
vertical axesBest used when the values are
very different
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-22
Inserting Sparklines in a Worksheet
SLO 3.6
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-23
Sparklines
Miniature charts displayed in a cell or cell range with your data
Illustrate trends and patterns without adding a separate chart
Three types: Line Column Win/Loss
Mic
rosoft
Offi
ce 2
013:
In P
racti
ce
3-24
Chapter Summary
SLO Summary
3.1 Create, size, and position an Excel chart object and create a chart sheet.
3.2 Design a chart using Quick Layouts and chart styles.
3.3 Switch row and column data, add or remove chart elements, change chart type, and edit source data.
3.4 Format chart elements with shape styles, fill, outlines, and special effects.
3.5 Use images, shapes, and WordArt in a chart.
3.6 Create a pie chart and a combination chart.
3.7 Insert and format sparklines in a worksheet.