Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My end user wants to view different background image for pivot table depending upon selection in region field.
How to achieve this?
just go to Expressions<<<<clik on + sign of expression and then fo to Background ooption.....
writ the set analysis expression...
...if(getselection(Field)=100,Red(),Green())
or whatever you need to implement>
Hi Sparten,
Go to chart properties> Visual Ques and give the upper & Lower values as 0 for column. & select the background color.
See the attachment,Hope it will help you.
Thank you.
but, I dont want to change the background clor instaed i want to change background image.
idea given by you works only for backgroung color.
Thanks Neha,
This is again related to backgroung color.
I want to change backgroung image of chart.
Thank you vishwaranjan.
I think this is something similar to what i want.
From where to access/open "Custom Format Cell" dialog box?
ok then just post a sample and which images you want to change
hi
keeping cursor on any value of pivote table then right clik, then you see the custom format cell option.
Hi Sparten,
You get "Custom Format Cell" option when you right click on the chart,Don't go in the chart properties below you get that option.