Microsoft Office Tutorials and References
In Depth Information
Key Terms
Ratio Data
Interval Data
Categorical/Nominal Data
Ordinal Data
Data Context
Records
Fields
Comment Field
Relational Database
Stacked Column
3-D Column
Line Chart
Time Series Data
Lags
Linear Trend
Systematic Behavior
Horizontal (Category) Axis Labels
Select Data, (Format) Chart Area,
Chart Type
Chart Title
Data Analysis
Collecting
Summarizing
Analyzing
Eyeballing
Presenting
Fishing Expedition
Sort Tool
Sort Keys
Charts and Graphs
Chart Wizard
Ribbons
Tabs
Groups
Chart Tools
Data Range
Column or Bar chart
Negative Correlation
Positive Correlation
Problems and Exercises
1. Consider the data in Table 2.3 of this chapter.
a. Replicate the charts that appeared in the chapter and attempt as many other
chart types and variations as you like. Use new chart types—pie, doughnut,
pyramid, etc.—to see the difference in appearance and appeal of the graphs.
b. Add another series to the data for a new product, F. What changes in graph
characteristics are necessary to display this new series with A-E? (Hint: scale
will be an issue in the display).
F
425
560
893
1025
1206
837
451
283
 
Search JabSto ::




Custom Search