Exploring Microsoft Office Excel 2007图表应用英文版教学讲义.ppt

Chapter 03: Lecture Notes (CSIT 104)
1
1
Chapter 3
Charts:
Delivering a Message
Exploring Microsoft Office Excel 2007
Chapter 03: Lecture Notes (CSIT 104)
2
Chapter 03 Objectives
Choose a chart type
Create a chart
Modify a chart
Enhance charts with graphic shapes
Embed charts
Print charts
Chapter 03: Lecture Notes (CSIT 104)
3
Charts
A chart is a graphic or visual representation of data
Multiple chart types can enhance information, adding visual appeal and making it easy to analyze data
Chapter 03: Lecture Notes (CSIT 104)
4
Choosing a Chart Type
Graphic representation of data
Attractive, clear way to convey information
Select the type of chart that best presents your message
Add enhancements to municate your information
Chapter 03: Lecture Notes (CSIT 104)
5
Choosing a Chart Type (continued)
Data point - numeric value that describes a single item on a chart
Data series - group of related data points
Category label - describes a group of data points in a chart
Chapter 03: Lecture Notes (CSIT 104)
6
Choosing a Chart Type
Which chart would best suit the data shown in the worksheet below?
Chapter 03: Lecture Notes (CSIT 104)
7
Questions to Ask
Percentage of the total revenue by city?
Percentage of total revenue by product?
Percentage of total revenue each product produces in each city?
Percentage of total revenue each city produces in each product?
Chapter 03: Lecture Notes (CSIT 104)
8
Column Charts
Used to show actual numbers rather than percentages
Displays parisons vertically in columns
The X or horizontal axis depicts categorical labels
The Y or vertical axis depicts numerical values
The plot area contains graphical representation of values in data series
The chart area contains entire chart and all of its elements
Chapter 03: Lecture Notes (CSIT 104)
9
Column Charts
Column chart displays the revenue of software sales by city
The height of the column reflects revenue of each city
Pittsburgh has the highest revenue and Buffa