Figure H Our new PivotChart. This type of chart provides a lot of information, and thanks to Excel’s two pivot objects, you won’t have to jump through hoops to produce it.

You could leave the chart as is, as a combo chart, as shown in Figure D, but let’s remove the lines so it’s strictly a floating bar chart. Figure D To finish the Excel chart, delete the lines.

This article explains how to create a report in Microsoft Excel using key skills like creating basic charts and tables, creating pivot tables, and printing the report. The information in this ...