excel+training - Excel charts and graphs

Hi Geraldine

Thank you for your question

This is a case where you might want to use a secondary data axis. This places another axis on the right side of the chart and plots the selected series against that axis, whilst leaving the other series plotted against the primary axis on the left hand side.

Simply right click on the series in question and select series propeties. On the resulting dialog select the axis tab and choose the secondary axis option button.

Hope this is useful

Regards

Stephen