How to Make Charts and Tables for an Excel Report Creating reports usually means collecting information and presenting it all in a single sheet that serves as the report sheet for all of the ...

Select the entire Table and then click Analyze Data. Figure C shows the first few results; there are three questions at the top and four charts.

Displaying values on a map chart is more meaningful than handing someone a sheet of data. Thanks to Microsoft Excel's Geography data type, creating a map chart is easier than you might think.