Excel 2007: Creating Charts with Dynamic Data

(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.