Change background Image Of Pivot Table Dynamically

[AbhijitBansode]

My end user wants to view different background image for pivot table depending upon selection in region field.

How to achieve this?

[sujeetsingh]

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>

[neha_shirsath]

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.

[AbhijitBansode]

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.

[AbhijitBansode]

Thanks Neha,

This is again related to backgroung color.

I want to change backgroung image of chart.

[#6]

hi

try this

1. Settings-> User preference -> Design -> Check "Always Show design menu item"

2. Right click on chart -> "Custome format cell"

[AbhijitBansode]

Thank you vishwaranjan.

I think this is something similar to what i want.

From where to access/open "Custom Format Cell" dialog box?

[sujeetsingh]

ok then just post a sample and which images you want to change

[#9]

hi

keeping cursor on any value of pivote table then right clik, then you see the custom format cell option.

[neha_shirsath]

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.