a picture is worth a thousand words. day 7: excel chapter 4 tazin afrin [email protected]...
TRANSCRIPT
![Page 1: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/1.jpg)
A Picture Is Worth A Thousand
Words
![Page 3: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/3.jpg)
3
CHART BASICS
• A chart is a visual representation of numeric data
• Chart components:– Data Points: numeric value that describes a
single value on a chart.– Data Series: a group of related data points.– Category Labels: text that describes a
collection of data points in a chart.
![Page 4: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/4.jpg)
4
SAMPLE DATASET
![Page 5: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/5.jpg)
5
COLUMN CHARTS
• A column chart displays data vertically, with each data series forming a column
• The chart area contains the entire chart and all of its elements.
• The plot area contains a graphical representation of values in a data series.
![Page 6: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/6.jpg)
6
COLUMN CHARTS
X
Y
Category axis
Val
ue A
xis
![Page 7: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/7.jpg)
7
LEGEND
• A legend is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart.
![Page 8: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/8.jpg)
8
CLUSTERED COLUMN CHART
• A clustered column chart groups or clusters similar data in columns to compare values across categories.
![Page 9: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/9.jpg)
9
CLUSTERED COLUMN CHART
Legends
![Page 10: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/10.jpg)
10
REVERSING CATEGORIES AND DATA SERIES
![Page 11: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/11.jpg)
11
STACKED COLUMN CHART
• A stacked column chart places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color.
![Page 12: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/12.jpg)
12
STACKED COLUMN CHART
![Page 13: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/13.jpg)
13
100% STACKED COLUMN CHART
• A 100% stacked column chart places (stacks) data in one column per category, with each column having the same height of 100%.
![Page 14: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/14.jpg)
14
100% STACKED COLUMN CHART
![Page 15: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/15.jpg)
15
3-D COLUMN CHART
• A 3-D chart adds a third dimension to each data series, creating a distorted perspective of the data.
![Page 16: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/16.jpg)
16
3-D COLUMN CHART
![Page 17: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/17.jpg)
17
BAR CHART
• A bar chart compares values across categories using horizontal bars.
![Page 18: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/18.jpg)
18
BAR CHART
![Page 19: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/19.jpg)
19
LINE CHART
• A line chart uses a line to connect data points in order to show trends over a period of time.
![Page 20: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/20.jpg)
20
LINE CHART
![Page 21: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/21.jpg)
21
PIE CHART
• A pie chart shows each data point in proportion to the whole data series as a slice in a circular pie.
![Page 22: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/22.jpg)
22
PIE CHART
![Page 23: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/23.jpg)
23
X Y (SCATTER) CHART
• An X Y (scatter) chart shows a relationship between two variables.
![Page 24: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/24.jpg)
24
X Y (SCATTER) CHART
![Page 25: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/25.jpg)
25
CREATING A CHART
• Select the data source• Select the chart type• Position and size the chart
![Page 26: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/26.jpg)
26
CREATING A CHART
• Shortcut Key:– Pressing F11 is a fast way to create a column
chart in a new chart sheet. Select the worksheet data source, and then press F11 to create the chart.
![Page 27: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/27.jpg)
27
CHANGING THE CHART TYPE
• Using the Chart Tools contextual tab:– Click the Design tab– Click Change Chart Type– Select the desired chart type
![Page 28: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/28.jpg)
28
CHANGING THE DATA SOURCE
• To modify the chart data source:– Click the Design tab– Click Select Data under the Data group– Then change data range
![Page 29: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/29.jpg)
29
MOVING A CHART
• To move a chart:– Click the Design tab– Click Move Chart under the Location group
![Page 30: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/30.jpg)
30
PRINTING A CHART
• To print an embedded chart:– Select the chart– Click the File tab– Click Print to display the Backstage view– Use the Print Selected Chart option
• To print a chart sheet:– Use the Print Active Sheet option
![Page 31: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/31.jpg)
31
CHART LAYOUT
• The Layout tab offers many ways to enhance a chart visually
• When adding visual elements to a chart, make sure these elements enhance the effectiveness of the chart instead of overpowering it.
![Page 32: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/32.jpg)
32
SELECTING AND FORMATTING CHART ELEMENTS
• Formatting a chart element:– Right-click the element and select the Format
element command– The element portion will change depending on
the selection (ex. Format Data Series)
![Page 33: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/33.jpg)
33
CUSTOMIZING CHART LABELS
• Chart Title• Axis Title• Legend• Data Labels• Data Table
![Page 34: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/34.jpg)
34
CHART TITLES AND LEGEND
• A chart title is the label that describes the entire chart
• An axis title is a label that describes either the category or value axis
• A legend is used to distinguish data points in a pie chart or data series in a multiple series chart
![Page 35: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/35.jpg)
35
AXES AND GRIDLINES
• Excel computes starting, ending, and incremental values for display on the value axis
• A gridline is a horizontal or vertical line through the plot area
![Page 36: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/36.jpg)
36
ADDING A TRENDLINE
• A trendline is a line used to depict trends and forecast future data
![Page 37: A Picture Is Worth A Thousand Words. DAY 7: EXCEL CHAPTER 4 Tazin Afrin Tazin.Afrin@mail.wvu.edu Tazin.Afrin@mail.wvu.edu September 10, 2013 2](https://reader037.vdocuments.us/reader037/viewer/2022110211/56649ec75503460f94bd31e5/html5/thumbnails/37.jpg)
THANK YOU LOG OFF