Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Greetings
Is it possible to change the color of the horizontal dimension in a pivot table.
Please find attach the qvw file.
Thanks
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.
did u tried custom format cell?
Hi,
Right click on the chart and select custom format cell option. You can format both dimension and expression cells in the displayed window.
is this?
sry
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.
Something along these lines?
Used Custom Format Cell as mentioned by Chanty 4u
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
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.
Thank You all for your quick response.