Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can I change the background color of table chart?
I wanna change the color of the column "total" with table chart.
Thank you.
Hi Louise,
You can use this Formula in Background Color Exp. in Pivot table
Pick(Dimensionality()+1, rgb(6,74,113),(Pick(Dimensionality(), rgb(240,255,255))))
This will not just color your total line but will color your subtotal line as well.
Hope this will help....🙂
you can change the color of the table by
click the table => select appearance =>select styling => background color
in background colors you can select the color you wish or u can use expression.
Hi Louise,
You can use this Formula in Background Color Exp. in Pivot table
Pick(Dimensionality()+1, rgb(6,74,113),(Pick(Dimensionality(), rgb(240,255,255))))
This will not just color your total line but will color your subtotal line as well.
Hope this will help....🙂
Thank you.
I'm gonna use pivot table instead of table chart.
Thank you so much!