Learn how to use pivot tables and charts in Excel and Google Sheets to summarize and visualize data for data analysis. Discover how to create, update, and refresh pivot tables and charts.

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.

If you wish to create a a Pivot Table and Pivot Chart in Excel, then this detailed article will guide you through the entire process.

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.