Display Behaviour

[Former Member]

Hai all

I had a selector (Combobox) for which i assigned different materials,if i select perticular material background Display should Change.how to Change?,

for that i taken for different different background for single combobox .

if(and(x=x, x < > 0),1,0) not woking in Status and Key also not woking

Edited by: nvnkmr12 on Jun 10, 2011 5:53 PM

Edited by: nvnkmr12 on Jun 10, 2011 5:53 PM

[Former Member · Accepted solution]

Hi,

Chart background should change or combo box????

Suppose ur combobox has 4 materials a, b, c, d.

If u select materail 'a', the corresponding graph or some other component will give u values corresponding to that selection rit?

now u wanted to have different canvas background /chartbackground ??? or for combo box???

if that is for chart/complete canvas background:

Goto Arts and background

drag and drop a background into canvas

set some background color to that component

goto combo box

goto behaviour tab of combo box .

Insert selected item:mapp that to a blank cell (Sheet1!$E$1)

goto behaviour tab of background component .

Status:mapp the cell Sheet1!$E$1 (insert Selected item cell of combo box (Sheet1!$E$1)).

Key: mapp material 'a'

place ur chart on this background and bring that to front....

follow the same for all material types b,c,d

Note :your chart should b on top of all the background components .

Hope this helps you

Regards,

Sri

[Former Member]

Hi

You can use dinamyc visibility and combine with excel function if().

Regards