How to Fix a Pivot Chart All Columns One Color

After you create a pivot table, you can insert a pivot chart, based on that pivot table. In this example, the chart shows sales data, per city, over two years. At first, all the chart columns are the same color, because there is only one series. To create columns with different colours, the field arrangement is changed. To create columns with different colors, move one of the fields into the Column area in the PivotTable Field List. NOTE: When a Pivot Chart is selected, the area names change -- Rows beco