Excel tutorial 4 enhancing a workbook with charts and graphs
This presentation is the property of its rightful owner.
Sponsored Links
1 / 18

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


  • 53 Views
  • Uploaded on
  • Presentation posted in: General

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 titles and legends Create and format a column chart. What You Will Do In Tutorial 4. Create and format a line chart

Download Presentation

Excel Tutorial 4: Enhancing a Workbook with Charts and Graphs

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


Excel tutorial 4 enhancing a workbook with charts and graphs

Excel Tutorial 4: Enhancing a Workbook with Charts and Graphs


What you will do in tutorial 4

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


What you will do in tutorial 41

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


Creating an excel chart

Creating an Excel Chart

  • Charts show trends or relationships in data that are difficult to show with numbers

  • Select a range to use as chart’s data source


Creating an excel chart1

Creating an Excel Chart

  • Three Chart Tools tabs appear on the Ribbon: Design, Layout, and Format


Moving a chart to a different worksheet

Moving a Chart to a Different Worksheet

  • Move Chart dialog box provides options for moving charts


Designing a pie chart

Designing a Pie Chart

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


Formatting data labels on a pie chart

Formatting Data Labels on a Pie Chart


Changing pie slice colors

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)


Column bar charts vs pie charts

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)


Editing the axis scale and text

Editing the Axis Scale and Text


Editing the axis scale and text1

Editing the Axis Scale and Text


Formatting the chart columns

Formatting the Chart Columns

  • Columns usually have a common format – distinguished by height, not color


Formatting date labels

Formatting Date Labels

  • Set minimum and maximum dates to use in the scale’s range

  • Set major and minor units as days, months, or years to use for the scale’s interval


Formatting date labels1

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


Overlaying a chart legend

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


Creating a line chart

Creating a Line Chart

  • Adding gridlines

  • Adding an axis title


Creating a 3 d chart

Creating a 3-D Chart


  • Login