Background color pivot and bar chart

[#1]

Hi,

I have a chart with a expression that has a calculated background color.

Now I want different calculations for the color depending on chart type, especially the pivot chart which doesn’t work that grate, se the pictures below.

Is there a way to do this? I haven’t found any function that detects chart type.

[Greg_Williams]

1 -  User Preferences > Design tab > check Always Show Design Menu Items > OK

2 -  Right click on what you want to change on the Pivot > Format Custom Cells (context menu) > Background color > Calculated color expression.

[#3]

The background color from the expression always overrides it.

In the expression "Alternativ" I have the color calculated to Blue().

In Pivot > Format Custom Cells (context menu) > Background color > Calculated color expression to White().

[Greg_Williams]

Can you share the file for me to look at?

[Anonymous]

i have had this issue before...two options that i know of:

1. use colors that work in both the charts if you use fast change

2. do not use fast change and a) use a container or b) a small icon toggle to switch between bar and pivot charts using conditional show.

[#6]

@jsaradhi suggestion has worked well. But it would be better if it could be done with fast change.