Double Graph Axis Problem

[JamesR12]

Hi!

Right, I'm attempting to make a double axis graph to show cost savings in a business and the level of particpation from staff. All the data is bogus.

My problem is probably really simple - just missing the obvious.

I am looking to make this graph (see attached) show along the Y axis

100k
80k
60k
40k
20k
0k

and in my other axis (for participation levels) I need from 0 - 100%


Apart from in my chart, the highest value is £30,000 and % of particpation is 70 - How can I get these chart axis to go beyond these figures and get the desired state as above?

Any help would be greatly appreciated.

James

[Andy Pope]

You would need to set the Maximum value of the axis to 100000 and 100.

For the primary value axis you can set the Display Units to Thousands and use number format
0k

For the secondary value axis you can use a number format as your values are not actually percentages.
0"%"

[JamesR12]

Thank you Andy!

I did find out that about 2 minutes after but still had trouble setting the secondary axis to a % which you have answered.

Rep added +

Cheers!