Excel Tutorial 4: Enhancing a Workbook with Charts and Graphs - PowerPoint PPT Presentation

Loading...

PPT – Excel Tutorial 4: Enhancing a Workbook with Charts and Graphs PowerPoint presentation | free to download - id: 57832f-MmMxY



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Excel Tutorial 4: Enhancing a Workbook with Charts and Graphs

Description:

Excel Tutorial 4: Enhancing a Workbook with Charts and Graphs What You Will Do In Tutorial 4 Create an embedded chart Create and format a pie chart Work with chart ... – PowerPoint PPT presentation

Number of Views:172
Avg rating:3.0/5.0
Slides: 19
Provided by: JuliaL153
Learn more at: http://www4.desales.edu
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Excel Tutorial 4: Enhancing a Workbook with Charts and Graphs


1
Excel Tutorial 4 Enhancing a Workbook with
Charts and Graphs
2
What You Will Do In Tutorial 4
  • Create an embedded chart
  • Create and format a pie chart
  • Work with chart titles and legends
  • Create and format a column chart

3
What You Will Do In Tutorial 4
  • Create and format a line chart
  • Modify a chart data source
  • Create and format a combined chart
  • Create a 3-D chart
  • Create and format sparklines and data bars
  • Create a chart sheet

4
Creating an Excel Chart
  • Charts show trends or relationships in data that
    are difficult to show with numbers
  • Select a range to use as charts data source

5
Creating an Excel Chart
  • Three Chart Tools tabs appear on the Ribbon
    Design, Layout, and Format

6
Moving a Chart to a Different Worksheet
  • Move Chart dialog box provides options for moving
    charts

7
Designing a Pie Chart
  • Choose location of the legend, and format it
    using tools on Chart Tools Layout tab

8
Formatting Data Labels on a Pie Chart
9
Changing Pie Slice Colors
  • Use distinct colors to avoid confusion,
    especially for adjacent slides
  • Format each slice rather than entire data series
    (each slice represents a different value in the
    series)

10
Column/Bar Charts vs Pie Charts
  • Column/bar charts are superior to pie charts
  • For large number of categories or categories
    close in value
  • Easier to compare height or length than area
  • Can be applied to wider range of data
  • Can include several data series (pie charts
    usually show only one data series)

11
Editing the Axis Scale and Text
12
Editing the Axis Scale and Text
13
Formatting the Chart Columns
  • Columns usually have a common format
    distinguished by height, not color

14
Formatting Date Labels
  • Set minimum and maximum dates to use in the
    scales range
  • Set major and minor units as days, months, or
    years to use for the scales interval

15
Formatting Date Labels
  • Custom date formats use combinations of m, d,
    and y for months, days, and years
  • Number of letters controls how Excel displays the
    date

16
Overlaying a Chart Legend
  • Makes more space for the plot area
  • An overlaid chart element floats in the chart
    area and is not fixed to a particular position
    can be dragged to a new location

17
Creating a Line Chart
  • Adding gridlines
  • Adding an axis title

18
Creating a 3-D Chart
About PowerShow.com