A Picture Is Worth A 	  			Thousand Words
1 / 37

A Picture Is Worth A Thousand Words - PowerPoint PPT Presentation

  • Uploaded on

A Picture Is Worth A Thousand Words. Day 7: Excel Chapter 4. Tazin Afrin Tazin.Afrin@mail.wvu.edu 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.
Download Presentation

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

An Image/Link below is provided (as is) to download presentation

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

Day 7:Excel Chapter 4

Tazin AfrinTazin.Afrin@mail.wvu.edu

September 10, 2013

Chart basics
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
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 charts1
Column Charts


Value Axis


Category axis


  • 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
Clustered Column Chart

  • A clustered column chart groups or clusters similar data in columns to compare values across categories.

Stacked column chart
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
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
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
Bar Chart

  • A bar chart compares values across categories using horizontal bars.

Line chart
Line Chart

  • A line chart uses a line to connect data points in order to show trends over a period of time.

Pie chart
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
X Y (Scatter) Chart

  • An X Y (scatter) chart shows a relationship between two variables.

Creating a chart
Creating a chart

  • Select the data source

  • Select the chart type

  • Position and size the chart

Creating a chart1
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
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
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
Moving a Chart

  • To move a chart:

    • Click the Design tab

    • Click Move Chart under the Location group

Printing a chart
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
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
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
Customizing Chart Labels

  • Chart Title

  • Axis Title

  • Legend

  • Data Labels

  • Data Table

Chart titles and legend
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
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

Adding a trendline
Adding a Trendline

  • A trendline is a line used to depict trends and forecast future data

A picture is worth a thousand words

Thank You

Log Off