Author
Released
12/4/2009- Creating an expanding chart using formulas
- Specifying the first point and the number of points for a series
- Plotting points at regular intervals in a series
- Filtering a PivotChart report to find the right information
Skill Level Intermediate
Duration
Views
(upbeat music) - Hi, I'm Curt Frye. Welcome to Excel 2007: Creating Charts with Dynamic Data. In this course, I'll show you how to visualize your data using charts you can control. I'll begin by showing you how to create dynamic named ranges and Excel tables, both valuable tools that enable you to create dynamic charts. Then, I'll demonstrate how to apply those techniques. We'll look at ways to create charts that expand to include all data entered into a range or Excel table, to determine how many data points you want to display in your chart, and to use a drop-down list to select which data series to visualize in your chart.
Finally, I'll show you how to create pivot charts, which enable you to reorganize and visualize your data on the fly. So, let's get started with Excel 2007: Creating Charts with Dynamic Data.
Related Courses
-
Outlook 2003 Essential Training
with David Rivers5h 45m Beginner -
Access 2003 Essential Training
with Mark Swift4h 55m Beginner -
Excel 2007 Essential Training
with Lorna Daly5h 13m Beginner -
PowerPoint 2007 Essential Training
with David Rivers6h 29m Beginner -
Publisher 2007 Essential Training
with David Rivers5h 47m Beginner -
Visio 2007 Essential Training
with David Rivers8h 55m Intermediate -
Outlook 2007 Essential Training
with Sean Conrad2h 37m Beginner -
Project 2007 Essential Training
with Lorna Daly3h 59m Beginner -
Access 2007 Essential Training
with David Rivers5h 27m Beginner -
SharePoint 2007 Essential Training
with David Rivers7h 48m Beginner -
Getting Started with Apple Color
with Robbie Carman1h 10m Beginner -
Acrobat 9 Pro: Creating Forms
with Brian Wood8h 37m Intermediate -
Acrobat 9 Pro Essential Training
with Brian Wood9h 34m Beginner -
Artist Series with Hillman Curtis
with Hillman Curtis51m 13s Intermediate -
Creative Inspirations: Margo Chase, Graphic Designer
with Margo Chase1h 18m Intermediate -
Margo Chase's Hand-Lettered Poster: Start to Finish
with Margo Chase14m 21s Intermediate -
Creative Inspirations: Ron Crabb, Digital Illustrator
with Ron Crabb1h 25m Intermediate -
Troika's ABC Brand Campaign: Start to Finish
with Troika Design Group21m 32s Intermediate -
CSS Positioning Best Practices
with Bill Weinman2h 32m Intermediate -
Creative Inspirations: Rick Smolan, Photographer
with Rick Smolan1h 19m Intermediate -
Learning GREP with InDesign
with Michael Murphy3h 45m Intermediate -
Mixing and Mastering with Pro Tools
with Brian Lee White9h 18m Intermediate -
Video Journalism: Shooting Techniques
with Jeff Sengstack2h 4m Intermediate -
Premiere Pro: Color Correction and Enhancement
with Jeff Sengstack5h 6m Intermediate -
Excel 2007: Financial Analysis
with Curt Frye2h 18m Intermediate -
Designing a Book Cover
with Nigel French2h 46m Intermediate -
Screencasting with the Mac
with Christopher Breen1h 51m Beginner -
Creative Inspirations: Ze Frank, Comedic Digital Savant
with Ze Frank56m 1s Intermediate -
Excel 2007: Pivot Tables for Data Analysis
with Curt Frye2h 45m Intermediate -
Excel 2007: Introduction to Formulas and Functions
with Curt Frye2h 26m Intermediate -
Windows 7 Essential Training
with David Rivers6h 31m Beginner -
Excel 2007 Power Shortcuts
with Michael Ninness2h 4m Intermediate -
Photo Assignment: Group Shots
with Derrick Story36m 11s Beginner
-
Introduction
-
Welcome48s
-
-
1. Defining Named Ranges
-
Creating a named range4m 51s
-
Creating an Excel table3m 5s
-
-
2. Creating Dynamic Charts Using Formulas
-
3. Sorting and Filtering PivotTable Data
-
Creating a PivotChart3m 24s
-
Pivoting a PivotChart2m 13s
-
Filtering a PivotChart1m 54s
-
-
Conclusion
-
Goodbye11s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome