Line Graph Help

[robinl]

Hi,

I would like to produce a line chart which on th verital axis has Utilisation and Horizontal is Margin %. In the attached I have drawn a rough image of how I would like it to look but have failed to recreate in the excel charts. The margin increases the lower the utilisation.

I appreciate any help on this.

Many thanks

[excelonthegrid]

you can create a x/y (scatter) chart with the utilisation values on the y-axis and margin values on the x-axis (specified in the select data area).

Then on each axis properties, tick the box to display values in reverse order and cross at maximum value.

I think that will get you there although the relationship is much more linear than your example