LUCKY FOR US ALL, given how important charts can be to the effective use and distribution of our data, they’re really easy to create. They’re even easier in Excel 2010, where simply selecting the data to be charted and clicking a button for the type of chart you want—Column, Bar, Pie, Line, and so on—gives you an instant chart.
Selecting the Right Source Data
The one tricky part of this very easy process is selecting the data to be charted. This is the point in the process with the largest margin for error, but you can eliminate that by understanding how charts work. Charts plot data points, which are grouped in logical data series, along a horizontal x or “category” axis, and a vertical ...