On the Insert tab, click the Column Chart button.The final step is to create a pivot chart, based on the pivot table. (Optional) Turn off Subtotals and Grand Totals - this will not affect the pivot chart.Add the number field to the Values area - Sales in this example.In the Columns area, add the fields you want to "stack" - Season number (Ssn) in this example.In the Rows area, add the fields you want in the chart's horizontal axis - Region and Year in this example.Next, add the following fields to the pivot table layout: Click OK, to create the blank pivot table.The Table/Range box should automatically show the name of the selected table.Select any cell in the source data table.To create a pivot table for the cluster stack chart, follow these steps: OR, follow the steps at the end of this page, to change your data layout.use the steps on the Cluster Stack Chart page to slightly rearrange the data, and build the chart.Here, there are 8 sales amounts in each region row, in a different column for each year/season combination.įor that type of data, try one of these suggestions: Instead of a named table, with each sales amount on a separate row, your data might be in a different layout, like this summary report of seasonal sales per region. If your data is in this layout, go to the Make a Pivot Table section below. all the Sales amounts are in a single column.each field is in a separate column: Region, Year, Season, Sales, Ssn (season number). To build a pivot table, the data should be in a named Excel table, like the one shown below, where: You can watch this short video, to see the steps for making a pivot table, and a clustered stacked column pivot chart. The "cluster" effect is created by the region labels and dividing lines below the horizontal axis Video: Make a Clustered Stacked Column Pivot Chart NOTE: This type of cluster stack chart has equal space between all the columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |