Pie Charts 2007 - Insert a new sheet name Step 6: Make the...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
DRAWING PIE CHARTS IN EXCEL 2007 Step 1: Enter data in column A and list categories in column B.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Step 2:Determine frequencies as follows: Step 3: Highlight the entries in columns B and C and click on INSERT tab. =COUNTIF(A2:A67,B2) Highlight the A2:A67 part Press F4 function key to add “$”
Background image of page 2
Step 4: Select Pie Chart and select the first 2-D Pie chart.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Step 5: Click Move Chart Location to put on another sheet
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Insert a new sheet name Step 6: Make the chart the way you want it to look by: (1) Highlighting the title and inserting an appropriate title: CAR COLOR; (2) Right mouse clicking on the entire pie chart and individual slices and using FORMAT DATA SERIES (Fill, Solid, choose color) to change colors of slices, and FORMAT DATA LABELS to delete legends, insert percentages, change color of labels, etc....
View Full Document

Page1 / 5

Pie Charts 2007 - Insert a new sheet name Step 6: Make the...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online