Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
I Think you need to work on your scale ie.
In your chart properties ... go to axes tab and change the scale accordingly
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
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)
Thank you.
helped me very much .
Thank you very much helped me.
Thank you .
helped me very much . thanks for the detail .
(and you were right about the differences in expression values)