Essential Skills Manual - Automotive Service Technician

TECHNICAL SKILLS

INVENTORY (TSI)

Automotive Service

Technician

NOC 7321

Direction

¾ Transfer each participant’s total for each Block both SE 2 - I need to
work on this and SE 3 - Not sure what this means into a Pie Chart;

o Highlight all of the Block titles in the “Summary Chart” on the

last page of the spreadsheet

o Hold down the Control Key (Ctrl) on your keyboard

o Highlight one client column

o On the tool bar, choose the “Chart Wizard”

(Microsoft Office Excel 2003)

o Under chart “Chart type” choose “Pie”

o Under “Chart Sub-Type” choose the first Pie picture

o Click “Next”

o Choose “Data Range” and “Columns” then click “Next”

o Choose “Titles” and fill in “Chart Name” (Client name and

Trade)

o On the same tool bar, choose “Legend” then “Bottom”

o On the same tool bar choose “Data Labels” then choose

“Category Name,” “Value,” and “Legend Key,” then click

“Next”

o Under Chart Location choose “As New Sheet” and click

“Finish”

o To change a colour of a piece of the pie chart so 2s and 3s in

the same piece of the pie match,

• click inside the pie


• click on the piece of pie you want to change


• double click on that same piece and the colour chart
  will appear


• choose your colour

o To move or adjust items in the pie chart, right click on the pie

chart, choose “Edit” then choose the item you want to adjust

or move. Click outside the chart when you are finished.

o Choose “Edit”, then “Copy” the pie chart and “Paste” it into

the “Individual Learning Plan”

Page 231 Automotive Service Technician

NOC 7321