creating an impact with charts. 2 managing workbooks new workbooks open with three worksheets can...
DESCRIPTION
3 Understanding Charts Embedded versus separate worksheets Both types update automatically when the data changes Embedded chart on a worksheet Chart on a separate sheetTRANSCRIPT
Creating an Impact with Charts
2
Managing Workbooks New workbooks open with three
worksheets Can hold up to the available amount of computer memory
Add, move, copy, and delete worksheets Change worksheet names
Worksheet tab
3
Understanding Charts
Embedded versus separate worksheets Both types update automatically when the data changes
Embedded charton a worksheet
Chart on aseparate sheet
4
Understanding Charts: Chart Types Chart types
Numerous purposes
Chart subtypes Various formats available for
each chart type 2-D and 3-D
SubtypesChart type
5
Understanding Charts: Chart Types Line
1 2 3
ApplesOranges
Banana
0
1
2
3
4
5
Apples
Oranges
Banana
Apples
Oranges
Banana
0
1
2
3
4
5
6
0 1 2 3 4 5
Oranges
Banana
Bar and column
Pie
6
Understanding Charts: Chart Wizard
Chart Wizard A guided, four-step
process Advance using Next
7
Column Charts and Bar ChartsCompare values using bars, either horizontally or vertically
Value axis – for quantities, amounts Category axis – often measures time
0
1
2
3
4
5
6
1 2 3
Category Axis
Valu
e A
xis
Apples
Oranges
Banana
8
Line ChartsCompare trends over time using horizontal lines
Value axis – The x-axis Category axis – The y-axis
x-axis
y-axis
9
Pie ChartsCompare parts of a whole
Contains only one data series and label
Apples
Oranges
Banana
2-D pie 3-D exploded pie
10
Moving and Sizing Embedded Charts
Diagonal double arrow: resizes proportionally
Compass arrow: moves
Vertical or horizontal double arrow: stretches
Select chart to display handles Mouse pointer changes to show moving and sizing
options
11
Previewing and Printing ChartsThe same as printing a worksheet, except…
Select the chart, if embedded Select the sheet, if on separate sheet
12
Formatting Charts
Chart wizard
Chart toolbar
Chart menu
Three formatting methods
13
Formatting Chart ObjectsFormat each object separately
Titles Legend
Data series
Exploded Piece
Background
Elevated Chart
Value axis
Category axis
14
Creating Diagrams Diagram Gallery
dialog box Six diagrams to
choose from
Creating an Impact with Charts