Notice this chart is the same as the one I created manually with the SUMIFS function. When I select sales by state, Excel creates a pivot table and inserts a chart in one step. We have options for sales by state, quantity by state, quantity by city, and so on. The brings up the familiar window with chart previews.īut notice that most options now show a small icon in the upper right. I'll start by placing the cursor anywhere in the data, then click Recommended Charts. Now let me create a pivot chart that shows the same summary. If I temporarily change a value in the data range, the chart updates immediately. Now if I insert a column chart using this data, the data used to plot the chart comes directly from the cells selected as source data. You can see the formula sums sales, using values from column B as criteria. On the second sheet here, I've built a small summary table that uses the SUMIFS function to get total sales for each state. Let's say I want to summarize sales by state.
To introduce the idea of a pivot chart, I'll first create a normal chart. Unlike normal charts, Pivot charts can be used to plot data with hundreds or thousands of rows.įor example, on this worksheet, I have order data from a wholesale chocolate company over a period of 2 years, in almost 2000 rows of data. Pivot charts let you rapidly analyze large amounts of unsummarized data in different ways. In this video, we'll introduce Pivot Charts.
0 kommentar(er)
