proportion between several bar charts

[dambeldor]

Hello everyone-

I have 6 bar charts with the same dimension: Year (2009, 2010, 2011, 2012), but with different expressions.

All the bars with different result.

I want the same ratio (proportion) in all of the charts.

for example: the bar with result -2 in one chart  will seem smaller than the bar with result 29 in another chart.

Is there any way to do this?

Thank you.

(see attached image)

[Anonymous]

I Think you need to work on your scale ie.

In your chart properties ... go to axes tab and change the scale accordingly

[Greg_Williams · Accepted solution]

Is it an option to use a horizontal gauge? Perhaps this will reflect the scaling better?

Change the Min/Max/Step values for the scale in Axes tab > chart properties.

Chart percentages instead of values themselves.

...some ideas.

-Greg

[maxgro]

you should use Static max in Axis tab; the max should be the same for every chart; you have to calculate it, I think in a similar way

rangemax(

  max(aggr(expr1, year)),

  max(aggr(expr2, year)),

  .....................  

  ) * 1.1

but in your case I suppose is useless because you have big differences in expression values (starting from 2 to 200000), so there is no way to find a common max (some bars would be too small to see it; perhaps with a log scale)

[dambeldor]

Thank you.

helped me very much .

[dambeldor]

Thank you very much helped me.

[dambeldor]

Thank you .

helped me very much . thanks for the detail .

(and you were right about the differences in expression values)