Put the pivot table that’s connected to the pivot chart on a separate.Then, when you change the pivotĬhart, only the original pivot table is affected. Right click on the chart, away from the columns and plot area, and click the Refresh command.Īs a workaround, you can create a second pivot table in your Excel workbook, based on theįirst one, and arrange it as you’d like. Tip: If the source data changes, you can refresh either the pivot table or the pivot chart, and both will update. If you want the pivot chart and pivot table to work independently. Unfortunately, there’s no setting you can change It doesn't matter if the pivot chart is on a new sheet, or the same worksheet as the pivot table - they stay connected. If you rearrange the fields in a pivot chart layout, the related pivot That creates a series for each city, and shows city's columns in a differentĬhanging Pivot Chart Layout Affects Pivot Table (Series) box, with OrderYr remaining in the Axis (Categories) box. In the next screen shot, the City field has been moved to the Legend That creates a series for each year, and shows one year in blue, and In the PivotChart Fields window, drag the OrderYr field from theĪxis box (Categories) to the Legend (Series) box.Click on the Pivot Chart, to select it.The Column area in the PivotTable Field List. To create columns with different colors, move one of the field names into The chart had only one series, so all the columns were

When the chart was created, the Year and Region fields were both in Watch this short video, to see the steps. To create columns with different colours, the field In this example, the chart shows sales data, per city, over two years.Īt first, all the chart columns are the same color, because there is Note: If you need help with creating a pivot chart, there are step-by-step instructions on the Pivot Chart Source Data page.After you create a pivot table, you can insert a pivot chart, based

Pivot charts mac excel 2013