3. Excel - 1 Chapter 3 – Graphs and Charts: Delivering a...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: 1 Chapter 3 – Graphs and Charts: Delivering a Message Exploring Microsoft Excel Tom 1% Dick 4% Har y 9% Ben 18% Ken 68% Ken pays 68% of the bill before the refund 2 What is a Chart? ¡ A graphic representation of data in a worksheet ¡ Chart elements ¢ Category labels – descriptive text entries ¢ Data points – numeric values ¢ Data series: a grouping of data points 3 Chart Types entertainment ¡ Keep it simple ¡ Use the appropriate chart type ¢ Pie and Exploded pie charts display proportional relationships ¢ Column charts display numbers rather than percentages ¢ Bar charts display numbers horizontally 4 Pie Charts food 40% living 15% communication 10% education 20% entertainment 15% Budget Each slice of the pie represents the percentage of this area\ in the family budget Slices are exploded Chart title 5 Column Charts Row 4 contains column headings and forms labels for X axis Embedded chart shows both the chart and the data 6 Creating A Chart ¡ Two ways to create ¢ Embed chart in worksheet ¡ Sizing handles allow you to size, move, copy, or delete an embedded chart ¢ Create in separate chart sheet ¡ Charts are linked to underlying data ¢ A change in the data instantly updates the chart(s) created on that data 7 Using the Chart Wizard ¡ Select the cells that contain the data ¡ Click the Chart Wizard button on the standard toolbar ¢ Select the chart type ¢ Check the data series ¢ Complete the chart options ¢ Choose the location 8 Choose the Chart Type Select any of the...
View Full Document

This note was uploaded on 10/25/2009 for the course BUSINESS 772 taught by Professor Sadeh during the Spring '07 term at Interdisciplinary Center Herzliya.

Page1 / 14

3. Excel - 1 Chapter 3 – Graphs and Charts: Delivering a...

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