The Change Chart Type utility in Microsoft Excel features several graphs from which you can select to convert your current Excel chart into a graph.

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.

Select B2:D8—the data you want in the chart. Include the header text so Excel can generate a legend automatically. Click Insert and then click Insert Column Or Bar Chart in the Charts group.