Combo chart and pivot table

[#1]

Hi,

I have combo chart Offshore and pivot table Clusters (see pic).

I need to resolve two issues:

1) in combo chart display bar expression Offshore like min and max range. Y axe scale have to stay 0-100%. Its possible? How?

2) If I scroll chart and pivot table for other values, i need to scroll both object at some time. Values in pivot table have to response to values in combo chart (columns bellow) I'm not sure if it is possible.

Eventually how can i put the expression from pivot table to combo chart?

Thanks for any help.

TP

[vivientexier]

For your first question : yes, it is possible.

Go on your chart properties, select the "Axes" tab ; on the top-right corner : check "Static min" and add "0" as a value, check "Static max" and add "1" as a value

[vivientexier]

I think the answer to your second question is : not possible.

[#4]

thanks fo reply, but i need to expression display like min and max range.

I painted it to the new pic🙂

[shree909]

i think when u expand the + sign of the expression

u fwill find a option show values..

in that specify the expression to show the max and min values whihc will be shown on the bAR...

but i doubt that we can show both the max and min values....

[vivientexier]

Ok, I see what you mean.

Go to your chart properties, then on "Espressions" tab. Click on "+" of your expression. One of the available option is "Bar offset" (where your bar will start - add your "Min value"). Then the value of your expression should be ("Max value" - " Min value"). That's all

[vivientexier]

Does this solves your problem?

If yes kindly close the post by marking it answered.