Exploratory Community

Pivot Table Coloring

#1

Hi - is it possible to choose which columns I want to color in a pivot table? Right now, it looks like the default colors the whole table. Thanks!

#2

Currently, you can only turn on/off the color for the entire Pivot Table.

If you use Table, you can set color per column. It provides a couple of visual formatting options. If you have data already summarized, you can just try it. If you don’t, you can summarize the data first, then try it.