Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Horizontal Dimension Color in Pivot table

Greetings

Is it possible to change the color of the horizontal dimension in a pivot table.

Please find attach the qvw file.

ThanksCapture.PNG

1 Solution

Accepted Solutions
Kushal_Chawda

Go to Settings->User Preferences ->Design->check the box "Always Show Design Menu Options"

Now right click on the Pivot table and click Custom Format Cells. Here you can select any cell and change the color.

View solution in original post

10 Replies
Chanty4u
MVP
MVP

did u tried custom format cell?

tamilarasu
Champion
Champion

Hi,

Right click on the chart and select custom format cell option. You can format both dimension and expression cells in the displayed window.

Capture.PNG

Chanty4u
MVP
MVP

is this?

Chanty4u
MVP
MVP

sry

jonathandienst
Partner - Champion III
Partner - Champion III

Right click on he values and select "Custom Format Cell". Select the font and background colours from the dialog and then in "Apply change to", choose Current Dimension.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
sunny_talwar

Something along these lines?

Capture.PNG

Used Custom Format Cell as mentioned by Chanty 4u

avinashelite

check the Design Grid option>from   Design tool bar (to view the tools bar go to view tool>design)

and then right click custom format cell appears ...chose the color according to your requirement

Kushal_Chawda

Go to Settings->User Preferences ->Design->check the box "Always Show Design Menu Options"

Now right click on the Pivot table and click Custom Format Cells. Here you can select any cell and change the color.

Not applicable
Author

Thank You all for your quick response.