Open the Excel file that has the chart you want to convert. Click on the chart to display the Chart Tools tab, and then click the "Design" tab.

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.