BTT 10 - Making Charts

Making a chart in Excel is easy if you follow these steps.

  • Highlight the data you want to make a chart with. If you want to highlight more than one set of data, highlight your first set, then hold down the ctrl button as you highlight your second set
  • After you have the data highlighted, go up to the insert tab and select the type of chart you want
  • After your chart appears on the screen, you can use the Design, Layout and Format Tabs along the top of MS Excel to edit your chart
  • Under the Design tab, you can change your chart type, your chart layout or your chart styles to make it look however you want
  • Under the Layout Tab is where you can add labels to your axes, a legend for your graph (useful in pie charts), a chart title, labels for your data (Instead of series 1, series 2)
  • Under the Format tab, you can further be creative with the way your excel graph looks

This is the basic information you need to get started! Play around with the program and charts as you work through the following examples.

  1. Make a pie chart for the following data. Use the text wrap feature for the headings. Include a title. See if you can make the percentages of each slice show up:

Ice Cream Type / Number who like it
Chocolate / 26
Vanilla / 23
Strawberry / 19
Cookie Dough / 12
Other / 6

Graph 1 should look like:

  1. The following stats were recorded from a soccer team. Create a bar graph. Include a title, label the axes:

Players / Goals
Kevin / 12
Keenan / 2
Sabrina / 15
Salome / 19
Gianni / 6

Graph 2 will look like:

  1. The following stats were recorded about the temperature in Toronto over a month. Make a line graph of the data. Include a title. Label the axes:

Day / Temperature
1 / 18
2 / 19
3 / 22
4 / 21
5 / 16
6 / 15
7 / 18
8 / 17
9 / 19
10 / 16
11 / 17
12 / 19
13 / 20
14 / 21

Graph 3 should look like:

Format the graphs to look nice. Ensure all necessary parts are labeled. When you are done, show your teacher so she can check it off for you in the book.

. BTT 10 – Charts in Excel Practice

1. Read the instructions below to create the following payroll spreadsheet.

MILLENIUM COMPUTER CONSULTANTS
Payroll: Week Ending October 25, 2013
Gross Pay / 25%
Employee # / Last Name / First Name / Hours / Hourly Pay / Gross Pay / Deductions / Net Pay
1 / Edwards / Rocco / 40 / $20.00
2 / Smith / Sarah / 40 / $25.00
3 / Ross / David / 40 / $18.00
4 / Davis / Fred / 44 / $29.00
5 / Foster / Susan / 35 / $35.00
6 / Tangi / Dona / 38 / $21.00
7 / Lynch / Bob / 25 / $18.00
TOTALS

Part 1:

Using your knowledge of Excel, you are to complete this spreadsheet using formulas.

Hints:

  1. Gross Pay is your Hourly Pay multiplied by the hours you worked.
  2. Use an absolute cell reference for deductions - 25% of gross pay.
  3. Net pay is your Gross Pay subtract Deductions.

Part 2:

  1. Create a column graph of hours worked and employees first name
  2. Create a pie graph of net pay to demonstrate who earns the most money
  3. Ensure all graphs have appropriate TITLES and LABELS
  4. Insert a hyperlink to a Canadian Bank somewhere on the sheet
  5. Insert a picture of a computer somewhere on the sheet