Skip this Video
Download Presentation
A Picture Is Worth A Thousand Words

Loading in 2 Seconds...

play fullscreen
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 [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.
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
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

Thank You

Log Off