Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi everyone,
in the pivot table below i got a design problem ( see red circle )
i tried right click -> cell format ... but no result !
any idea on how to resolve this problem ?
Is there any Dimension for the same ?
Can you share your sample application pls.
Vikas
here is (updated)
Hii Put your cursor on column line header side here here it comes like + arrow then expand or collapse it
thanks but your technic don't resolve this issue
my problem is the cell with dark gray background and it's borders color
You don't have a problem here. If you lable the dimensions you will see that your data is presented well. The question is: is this the most efficient way to present your data?
yes it's the most efficient way, but if only i can change the dark dray to white
OK, then try a Style on the Style tab.
Example:
Current style = Clean
Cell background Color Transparency = 100%
it's don't fix my problem because i want to keep the yellow header color and if i use the Clean style all colors are gone because of the transparency