You can see the Pivot Chart button opens exactly the same window with the same options. I'll undo that and let's try the Pivot Chart button. When you choose an option, you'll get a new pivot chart linked to the pivot table. In cases where chart types won't work with a pivot table, you'll see a message to that effect. Recommended charts will show you previews of chart options, although strangely the pivot table icon is missing. Now, if you already have a pivot table, you can use either of the options we just covered to add a pivot chart, just make sure you select a cell in the pivot table first instead of the data. From there, you can add fields to either to build the chart. When you click OK, you'll get a new blank pivot table and blank pivot chart. This option opens the create pivot table window, where you can confirm the data source, and choose a worksheet location. In that case, use the Pivot Chart button on the Insert tab of the ribbon. If the data set is too large, recommended charts won't work, and you'll get a message that says recommended charts is not available. When you select a pivot chart option, Excel creates the chart and pivot table on a new worksheet, configured as shown in the preview. If you don't have too much data, recommended charts will suggest pivot chart options with the small pivot icon in the upper right. In this video, we'll look at several options for creating a pivot chart.Ī pivot chart is an extension of a pivot table, so in order to have a pivot chart you must also have a pivot table.Įxcel provides several ways insert a pivot table and pivot chart in one step.
0 kommentar(er)
