Excel 2007 Chart by stk10617

VIEWS: 40 PAGES: 20

More Info
									Microsoft Excel 2007 -
     Illustrated

  Enhancing Charts
        Objectives
     • Customize a data series
     • Change a data source and add data
       labels
     • Format the axes of a chart
     • Add a data table to a chart




Microsoft Office Excel 2007 - Illustrated   2
         Objectives
     •     Rotate a chart
     •     Enhance a chart with WordArt
     •     Add a picture to a chart
     •     Identify data trends




Microsoft Office Excel 2007 - Illustrated   3
       Customizing a Data Series

     • A data series is the information,
       usually numbers or values, that Excel
       plots on a chart




Microsoft Office Excel 2007 - Illustrated      4
   Changing a Data Source and
      Adding Data Labels
     • Descriptive text, called a data label,
       appears above a data marker in a
       chart




Microsoft Office Excel 2007 - Illustrated       5
      Changing a Data Source and
       Adding Data Labels (cont.)

        Data label




Microsoft Office Excel 2007 - Illustrated   6
Formatting the Axes of a Chart

     • Excel plots and formats chart data
       and places the chart axes within the
       chart’s plot area
              • Data values in two-dimensional charts
                are plotted on the y-axis and categories
                are plotted on the x-axis
                     • A scale is created for the value (y) axis
                       that is based on the highest and lowest
                       values in the data series


Microsoft Office Excel 2007 - Illustrated                          7
Formatting the Axes of a Chart
(cont.)
         • Three axes are generated in three-
           dimensional charts; x-axis (category),
           z-axis (value), and y-axis (chart depth)
                 • Z-axis usually contains the scale for the
                   chart
                 • Override Excel default formats for chart
                   axes using the Format Axis dialog box




Microsoft Office Excel 2007 - Illustrated                      8
 Formatting the Axes of a Chart
 (cont.)
        Value (z)
          axis


        Maximum
         value


        Minimum
         value




Microsoft Office Excel 2007 - Illustrated   9
Adding a Data Table to a Chart

     • A data table is a grid containing the
       chart data, attached to the bottom of
       a chart
              • Data tables are useful because they
                highlight the data you used to generate
                the chart




Microsoft Office Excel 2007 - Illustrated                 10
 Adding a Data Table to a Chart
            (cont.)




       Data table




Microsoft Office Excel 2007 - Illustrated   11
   Rotating a Chart

     • By rotating a 3-D chart, you can
       improve the visibility of the chart data
     • Depth can be increased to improve
       visibility of chart data




Microsoft Office Excel 2007 - Illustrated     12
    Rotating a Chart (cont.)

        Increased
        depth and
         rotation




Microsoft Office Excel 2007 - Illustrated   13
          Enhancing a Chart with
                WordArt
     • Enhance a chart or worksheet by
       adding specially formatted text
              • Format WordArt using 3-D effects and
                shadows
              • WordArt text is considered an object




Microsoft Office Excel 2007 - Illustrated              14
            Enhancing a Chart with
               WordArt (cont.)



      WordArt text




Microsoft Office Excel 2007 - Illustrated   15
    Adding a Picture to a Chart

     • Enhance a chart by adding a picture
       to the data markers, chart area, plot
       area, legend, or chart walls and
       floors




Microsoft Office Excel 2007 - Illustrated      16
         Adding a Picture to a Chart
                   (cont.)



        Picture
      added to the
       back wall




Microsoft Office Excel 2007 - Illustrated   17
            Identifying Data Trends

     • Creating a trendline
              • Trendlines graphically represent data
                trends
              • Emphasize patters in data
              • Predict future data based on past
                trends




Microsoft Office Excel 2007 - Illustrated               18
    Identifying Data Trends (cont.)


         U.S.
       Trendline



          U.K.
        Trendline




Microsoft Office Excel 2007 - Illustrated   19
                 Summary

     • Customize data series
     • Format chart axes and add data
       tables
     • Rotate a chart
     • Use WordArt to enhance charts
     • Add pictures to charts
     • Identify data trends

Microsoft Office Excel 2007 - Illustrated   20

								
To top