create pie chart in excel using different data

Ensure the source data is complete and accurate.

The steps to create a pivot chart in Excel are:

Thus, the pivot chart enables us to compare the sales generated by specific sales representatives or the chosen products, making it highly dynamic. The chart offers two filters, one for filtering products and the other for sales representatives. Later, we will see how to add a pivot chart to a new worksheet. In the above pivot chart in Excel example, the graph gets plotted according to the pivot table in the cell range E1:I12, in the same sheet as the source data. Once we create a pivot table and insert pivot chart in Excel, the graph will appear as depicted below:

Thus, the pivot chart is the best option users can use when summarizing, reviewing, or presenting massive data in sales and executive reports.įor example, consider the below table showing the sales data of sales representatives. It offers interactive filtering options that make analyzing the selected data quick and straightforward. Pivot chart in Excel is an in-built Excel feature that visually summarizes complex data and trends.

Create pie chart in excel using different data