Bar Charts 2007 - Click OK Step 6: Make the chart the way...

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

View Full Document Right Arrow Icon
DRAWING BAR 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
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 4:  Select Pie Chart and select the first Column chart.
Background image of page 4
Step 5:  Click Move Chart Location to put on another sheet  Insert a new sheet name
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Click OK 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 / 6

Bar Charts 2007 - Click OK Step 6: Make the chart the way...

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

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