excel tutorial 4 enhancing a workbook with charts and graphs
Download
Skip this Video
Download Presentation
Excel Tutorial 4: Enhancing a Workbook with Charts and Graphs

Loading in 2 Seconds...

play fullscreen
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
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
ad