Make axes in a combochart more flexible?

[datanibbler]

Hi,

I'm not sure that I have not asked this before - but I am currently working on a KPI where this is an issue:

- The issue to display is goods_receipt in the categories "lorrys" and "containers"

- I have to display these as well as the manpower used and the quota.

=> The problem is, there are logically only relatively few lorrys, but a lot of containers
=> For that reason I cannot show them both on the same axis

=> The manpower used is in a range compatible to that of the lorrys, but not to that of the containers

I cannot (or don't know how to) make the axis of a single chart flexible so that, depending on whether I want to display the nr. of lorrys or the nr. of containers in the chart (together with the manpower), all the axes are on the left (so there is only one since I can display the manpower on the same axis as the nr. of lorrys)

or one axis is left and one right (in the case of containers, I have to chart the manpower on the right axis)

=> Can anyone advise me how to do this?

Thanks a lot!

Best regards,

DataNibbler

[whiteline]

Could you also explain what the reason is to display all of this stuff on the same chart.

Usually if you want to show some relation there is no need to keep absolute values so you can use ratios.

[datanibbler]

Hi whiteline,

that's right - but I want to show both:

- the nr. of lorrys/ the nr. of containers

- the manpower (employee_hrs) used

- the ratio

Also - even if I were not to show the absolute values, but only the ratio - I could not show the ratio rgd. lorrys (lorrys per emp_hrs) on the same scale as >containers per emp_hrs< because the latter is of course (hopefully) much higher.

The issue is, the decision whether an axis is to be displayed on the left or right of a chart is only a checkbox where I cannot use a formula based on the category.

What I was doing thus is making a copy of the chart and giving the two opposite visibility_conditions - so I have one chart for the nr. of lorrys where I can the values and the quota all on the same axis, and one for the containers where the nr. of containers goes on one axis together with the quota, the nr. of emp_hrs on another.