A Picture Is Worth A Thousand Words

1 / 37

# A Picture Is Worth A Thousand Words - PowerPoint PPT Presentation

A Picture Is Worth A Thousand Words. Day 7: Excel Chapter 4. Tazin Afrin [email protected] September 10, 2013. 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.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about ' A Picture Is Worth A Thousand Words' - ilya

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

### Day 7:Excel Chapter 4

Tazin [email protected]

September 10, 2013

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.
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.
Column Charts

Y

Value Axis

X

Category axis

Legend
• A legend is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart.
Clustered Column Chart
• A clustered column chart groups or clusters similar data in columns to compare values across categories.
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.
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%.
3-D Column Chart
• A 3-D chart adds a third dimension to each data series, creating a distorted perspective of the data.
Bar Chart
• A bar chart compares values across categories using horizontal bars.
Line Chart
• A line chart uses a line to connect data points in order to show trends over a period of time.
Pie Chart
• A pie chart shows each data point in proportion to the whole data series as a slice in a circular pie.
X Y (Scatter) Chart
• An X Y (scatter) chart shows a relationship between two variables.
Creating a chart
• Select the data source
• Select the chart type
• Position and size the chart
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.
Changing the Chart Type
• Using the Chart Tools contextual tab:
• Click the Design tab
• Click Change Chart Type
• Select the desired chart type
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
Moving a Chart
• To move a chart:
• Click the Design tab
• Click Move Chart under the Location group
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
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.
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)
Customizing Chart Labels
• Chart Title
• Axis Title
• Legend
• Data Labels
• Data Table
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
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