Microsoft Excel 2007 - Illustrated - PowerPoint PPT Presentation

Loading...

PPT – Microsoft Excel 2007 - Illustrated PowerPoint presentation | free to download - id: 3f8a1c-MGRlN



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Microsoft Excel 2007 - Illustrated

Description:

Microsoft Excel 2007 - Illustrated Enhancing Charts * Microsoft Office Excel 2007 - Illustrated Customize a data series Change a data source and add data labels ... – PowerPoint PPT presentation

Number of Views:110
Avg rating:3.0/5.0
Slides: 21
Provided by: DavidB372
Learn more at: http://www.srvc.net
Category:

less

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

Title: Microsoft Excel 2007 - Illustrated


1
Microsoft Excel 2007 - Illustrated
Enhancing Charts
2
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

3
Objectives
  • Rotate a chart
  • Enhance a chart with WordArt
  • Add a picture to a chart
  • Identify data trends

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

5
Changing a Data Source and Adding Data Labels
  • Descriptive text, called a data label, appears
    above a data marker in a chart

6
Changing a Data Source and Adding Data Labels
(cont.)
Data label
7
Formatting the Axes of a Chart
  • Excel plots and formats chart data and places the
    chart axes within the charts 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

8
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

9
Formatting the Axes of a Chart (cont.)
Value (z) axis
Maximum value
Minimum value
10
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

11
Adding a Data Table to a Chart (cont.)
Data table
12
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

13
Rotating a Chart (cont.)
Increased depth and rotation
14
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

15
Enhancing a Chart with WordArt (cont.)
WordArt text
16
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

17
Adding a Picture to a Chart (cont.)
Picture added to the back wall
18
Identifying Data Trends
  • Creating a trendline
  • Trendlines graphically represent data trends
  • Emphasize patters in data
  • Predict future data based on past trends

19
Identifying Data Trends (cont.)
U.S. Trendline
U.K. Trendline
20
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
About PowerShow.com