Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Coloring the top left or bottom left cell of Pivot table

Hi guys,

Sometimes when we create a pivot table with multiple dimensions, then we get a cell either at top left or bottom left that has the grey color. I'm wondering that if there is a way to color that cell or hide that cell in some way.

Please suggest!!!

-Abhishek

5 Replies
suresh_rawat
Creator II
Creator II

Hi Abhishek,

If your pivot table is not dynamic then we can put a text box on that space and write something related to the chart.

Else we can do is to convert that grey color to white. For that kindly refer the attachment below.


Capture.PNG.png

Regards

Suresh Rawat

Anonymous
Not applicable
Author

Thanks Suresh for your response!!!

I've already tried both the options and putting a textbox on that grey cell will the last option I use in case if we can't figure out the proper approach.

And if we do the "Cell background color transparency" to 100% then it will apply to all the cells and that's what I don't want. Because we have corporate color policies and because of that I just need to color that particular cell as per the policies.

Thanks for your help!!!

-Abhishek

suresh_rawat
Creator II
Creator II

Abhishek,

Yes with the transparency - it will apply to all cells.

So, I think textbox will be the last option.

Regards

Suresh Rawat

Not applicable
Author

Hi Abhishek,

You can try following steps, I have not tried myself so not sure:

1. Chage the view to Grid from Menu-Design Grid or ctrl+G.

2. Right click on that particular cell and click on "Custom Format Cell".

There you can change the background color for a particular cell.

Hope this helps!

suresh_rawat
Creator II
Creator II

Hi Shyamal,

After doing this, it will change the background color for all the healer cells if we select any particular healder cell in a table.

Regards

Suresh Rawat