{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

3. Excel - Computer Application in Management Yosi Wiesel...

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

View Full Document Right Arrow Icon
1 Chapter 3 – Graphs and Charts: Delivering a Message Exploring Microsoft Excel Tom 1% Dick 4% Harry 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
Image of page 1

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

View Full Document Right Arrow Icon
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
Image of page 2
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
Image of page 3

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

View Full Document Right Arrow Icon
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
Image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}