question about chart colours

[Anonymous]

Hi,

Is it possible to change chart colours by clicking on a bar inside a graph?

Please see my question in detail in the file attached.

Thank you in advance,

Larisa Filonova

[morganaaron]

Hi Larisa,

Yes - if you ensure that your expressions include the state {1} so that no selections affect the chart, then you can alter the 'background color' expression within your overall expression. If you type in:

if([Your Field] = [Your Field]
, ”
, RGB(200,200,200)
)

RGB() you can replace with whatever colour you want the "non-selected" values to be. The colour they'll show will then be the colour each bar was before - so you can use persistent colours or whichever desired colour you want.

It'll claim the syntax is wrong, but it works!

[Gysbert_Wassenaar]

Yes, it's possible. See attached example.

[Anonymous]

I'd like to make a selection of several bars (e.g. Lemon and Cherry) by clicking on bars without using a list box.

I tried to select a second bar using Ctrl or Shift button. Neither of them works. How is it possible?

[robert_mika]

To select more than one bar

Hold left mouse button and highlight two or more bars

[Anonymous]

But in this case you select only those bars that are next to each other.

How can I select the first and the fifth bar for instance?

[robert_mika]

Hold CTRL and then click with left mouse button the bars you want to be shown and release CTRL

All bars

Selected:

[Anonymous]

Hi

I don't quite see what you mean.

Please see the file attached. For instance, I have selected the lemon bar, then I want to select the orange bar. If I click on the bar with the left muse button (plus Ctrl), then a menu appears but the orange bar isn't selected.

How can I select both lemon and orange bar?

Thank you in advance,

Larisa Filonova

[robert_mika · Accepted solution]

Holding Control Key .

Point to Lemon bar -click with left mouse button

go to Orange bar-click with left mouse button

release control Key