How to always show an expression?

[#1]

Hi all,

I have a radar chart, which uses a macro to show/hide expressons depending on what the user has selected.

BUT I want the expression : My Group, to always show.

Does anyone have an idea in which I always show this expression, but allowing the others to be optional.

Many thanks

[#2]

Any ideas on this one?

The 'My Group' expression disappears once I've selected which expressions to show (using the tickbox on the right)

Maybe through the Conditional box on the 'Expressions' tab. - Not sure?

[SunilChauhan]

you need to check always in layout

chart properties->layout->check always radio

thanks

Sunil Chauhan

[#4]

Even though this radio button is checked as 'always', the expression-My Group seems to always hide.

[SunilChauhan]

Control+M

Control+A

comment macro

[#6]

I tried this, but nothing really happens.?

[Anonymous]

Did you try to add "My Group" to your inline script?

Like:

[Expressions]:

replace LOAD * INLINE [

Expressions

My Group

UK Average

Group1

Peer Group

];

What happens then?

[#8]

Thanks for the response.

Unfortunately this doesn't really do much.

hmmmm?

[#9]

hI beanz,

if i've understood well, why don't you use an if like this?

if(e.ExpressionVisual.Label.v="My Group")          then

                                                  expression.Enable = TRUE

                                                  ELSE

                                                  expression.Enable = FALSE               'disable the expression

                                        end if

So My Group is always enable.

But maybe it's too easy, i haven't understood surely..

C u,

Stefano

[#10]

I'm getting there.BUT I'd like the macro to run for a number of charts.

As soon as I add multiple charts in the macro editor -

set chart            = ActiveDocument.getSheetObject("CH15")

set chart            = ActiveDocument.getSheetObject("CH14")

set chart            = ActiveDocument.getSheetObject("CH22")

It ignores the macro each time.

Is there anyway I can change the macro to allow this functionality to run on all Charts.?