Excel Charts & Graphs
Created by Kristi Hamilton Ithaca Michigan
E X C E L
C H A R T S
&
G R A P H S
Table of Contents TYPES OF CHARTS ............................................................................................ 3 AREA ................................................................................................................... 3 BAR ..................................................................................................................... 3 BUBBLE ................................................................................................................ 4 COLUMN............................................................................................................... 4 CONE, CYLINDER, AND PYRAMID ............................................................................ 5 DOUGHNUT .......................................................................................................... 5 LINE ..................................................................................................................... 6 PIE ...................................................................................................................... 6 RADAR ................................................................................................................. 7 SCATTER .............................................................................................................. 7 STOCK ................................................................................................................. 8 SURFACE ............................................................................................................. 8 CREATING GRAPHS ........................................................................................... 9
Page 2
E X C E L
C H A R T S
&
G R A P H S
Excel allows you to take your data that you enter in a spreadsheet and put a graph or chart in your spreadsheet.
Types of Charts
Area
Bar
Page 3
E X C E L
C H A R T S
&
G R A P H S
Types of Charts (Continued) Bubble
Column
Page 4
E X C E L
C H A R T S
&
G R A P H S
Types of Charts (Continued) Cone, Cylinder, and Pyramid
Doughnut
Page 5
E X C E L
C H A R T S
&
G R A P H S
Types of Charts (Continued) Line
Pie
Page 6
E X C E L
C H A R T S
&
G R A P H S
Types of Charts (Continued) Radar
Scatter
Page 7
E X C E L
C H A R T S
&
G R A P H S
Types of Charts (Continued) Stock
Surface
Page 8
E X C E L
C H A R T S
&
G R A P H S
Creating Graphs
Open Excel o Start o Programs o Microsoft Excel Enter in the data
Expenses Six Month Overview January Electric Supplies Parts Heat Phone $50.00 $20.00 $100.00 $80.00 $75.00 February $50.00 $10.00 $200.00 $80.00 $80.00 March $50.00 $60.00 $50.00 $65.00 $50.00 April $60.00 $30.00 $25.00 $50.00 $50.00 May $70.00 $10.00 $100.00 $30.00 $75.00 June $70.00 $50.00 $50.00 $30.00 $50.00
Click Insert Click Chart
This will bring up the chart wizard It will walk you through creating the chart or graph the way you would like it to look
Page 9
E X C E L
C H A R T S
&
G R A P H S
CREATING GRAPHS (CONTINUED)
Click Column Next
Tell it the range of data that you entered in o Click on the little sheet button that looks like a small spreadsheet with a red arrow o This will make the window much smaller o Select the data by highlighting the cells Click Next
Page 10
E X C E L
C H A R T S
&
G R A P H S
CREATING GRAPHS (CONTINUED)
Titles o
o
Give the Chart the Title Expenses We are not going to label the axes
Axes Leave it the default
Page 11
C R E A T I N G
G R A P H S
E X C E L C H A R T S ( C O N T I N U E D )
&
G R A P H S
Gridlines o Leave it default
Legend o Leave it default
Page 12
E X C E L
C H A R T S
&
G R A P H S
CREATING GRAPHS (CONTINUED)
Data Labels o Leave at default
Data Table o Leave Defaults
Page 13
E X C E L
C H A R T S
&
G R A P H S
CREATING GRAPHS (CONTINUED)
Place Chart o Click As new sheet o Click Finish
Your Chart should show up on a new sheet
Page 14