How-To Series
The Essentials of Working with Charts in Excel 2007
The essentials of creating and working with charts in Excel 2007 will show you everything you need to know to convert your numbers into charts that can help your audience understand the meaning behind the data and make that data stand out.
Most Popular
Formatting Charts in Excel
Formatting the X-axis and Y-axis in Excel 2007 Charts
When charting values, Excel 2007 isn’t always careful how it formats the values that appear on the y-axis (or the x-axis when using some chart types, such as the 3-D Column chart or the XY Scatter chart [more…]
Using Tables in Excel
Create a Pivot Table in Excel 2007
A pivot table is a special type of summary table that’s totally unique to Excel 2007. Pivot tables are great for summarizing values in a table because they do their magic without making you create formulas [more…]
Understanding Excel
Using Built-in Add-In Programs in Excel 2007
Add-in programs are small modules that extend the power of Excel 2007 by giving you access to a wide array of features and calculating functions not otherwise offered in the application. There are three [more…]
Creating Charts in Excel
Getting to Know the Parts of an Excel 2007 Chart
The typical chart (or graph) in Excel 2007 comprises several distinct parts, including the chart area, data series, axes, legend, plot area, gridlines, data markers, and more. The following list summarizes [more…]
Using Tables in Excel
Filtering and Sorting an Excel 2007 Pivot Table
You can filter and sort the data in an Excel 2007 pivot table to display a subset of data arranged how you want to view it. Excel automatically adds drop-down filter arrows to the Report Filter field as [more…]
