Excel tutorial 4 enhancing a workbook with charts and graphs
Download
1 / 18

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


  • 104 Views
  • Uploaded on

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

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

PowerPoint Slideshow about 'Excel Tutorial 4: Enhancing a Workbook with Charts and Graphs' - peggy


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



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)




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