You can use Control-Z to step backwards until the pivot table is in good shape, then start experimenting again. I've looked for this setting, but simply can't find it. This is to avoid the disturbing resizing shown in the gif below: I'm using Office 365 Home. I want to set a fixed x-axis on my chart, e.g. If we put a numeric field like Quantity into the row labels area, the pivot table breaks out product sales by product, and then by quantity, which is interesting but not especially useful.Īs you experiment with different pivot table configurations, keep the Undo command at the ready. Per default, Excel changes the axis to fit the data. Numeric fields are normally placed in the Values area. The pivot table now shows product sales with products grouped by Category. However, if we move the Category field so that it appears before Product, we get a configuration that does make sense. When you're working with a pivot table, you can move fields from one area to another at any time. This is where the idea of Pivot comes from. Each time you move a field, you see another view of the same data, in a different orientation. If we try that, The pivot table rebuilds itself correctly, but the structure isn't useful, since each product appears in only one category. Moving fields around in a pivot table is fun and even addictive. For example, it doesn't make sense to have Product appear above Category. Note that the order that the fields appear is reflected in the pivot table. Let's remove Region and add Category under products. Product sales are now grouped by Region first, and then State. In this same way, we can look at product sales by region and state by adding State to the Column labels area. We can just drag the fields to swap locations.Īnd drag them back again to restore the original orientation. In this pivot table, we have the Product field in the Row Labels area and Region in the Column Labels areas. The easiest way to move a field is just to drag it from one area to another. Each time you move a field, the pivot table will rebuild itself to respect the new field configuration. You can follow the question or vote as helpful, but you cannot reply to this thread. I need to move the secondary vertical axis to the right side of the graph. This is where the idea of Pivot comes from. Moving a Secondary Vertical Axis in Excel Both the primary and secondary vertical axes are posting on the left side of the graph. This will add a secondary axis and give you two bars. In the right-pane that opens, select the Secondary Axis option. With the Profit margin bars selected, right-click and click on ‘Format Data Series’. Each time you move a field, you see another view of the same data, in a different orientation. If these are too small to select, select any of the blue bars and hit the tab key. Moving fields around in a pivot table is fun and even addictive.