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. See how to change the chart layout, after you build it.

Columns All One Colour

When you first insert a pivot chart, all the chart columns will be the same color, if there is only one series.  The chart shown below is based on a pivot table that has Order Year and City in the Row area, and Cases in the Value area.

pivotchartlayout01

Change the Layout

If you want a chart with columns in different colours, the field layout will have to be changed.

NOTE: This will also change the layout of the pivot table on which the chart is based.

To move a field, follow these steps:

  • Click on the Pivot Chart, to select it.
  • In the PivotChart Fields window, drag a field from the Axis (Categories) box, to the Legend (Series) box.

pivotchartlayout04

That creates a series for each item in that field, and shows each series (each Year) in a different color.

pivotchartlayout02

Or, you could leave the Year field in the Axis (Categories) box, and move the City field to the Legend (Series) box.

That will create columns with a different colour for each series (each City).

pivotchartlayout03

Get the Sample File

Visit the Pivot Chart page on my Contextures website to get the sample file.

Watch the Video

Watch this short video to see how to insert a pivot chart, and show the series in columns of different colours.

____________________

This entry was posted in Pivot Chart. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *