Lynda - Excel 2007: Creating Charts with Dynamic Data - 58704
Lynda - Excel 2007: Creating Charts with Dynamic Data
Excel 2007: Creating Charts with Dynamic Data shows how simple data in Excel can be used to build exciting and updatable charts. Microsoft Most Valuable Professional Curt Frye explains how to use both named ranges and Excel tables to create charts that adjust as the data changes. Curt demonstrates how to specify the number of points in a chart and how to use a drop-down list to select which data series is displayed. Finally, he shows how to use PivotChart reports to reorganize and visualize data on the fly. Exercise files accompany the course.


Table of Contents

  • Introduction
  • 1. Defining Named Ranges
  • 2. Creating Dynamic Charts Using Formulas
  • 3. Sorting and Filtering PivotTable Data
  • Conclusion
  • Lynda - Excel 2007: Creating Charts with Dynamic Data


    Information
    Members of Guests cannot leave comments.




    rss