Chart 2 axis

[Dave]

Hi, I want to be able to put three different series in a chart. One one a
target value, one a revenue value and the other a percentage.

I can see that excel has a Line - Column on 2 axes, however, I would like
two on a line and one on a column. Is there anyway I can change this?

Thanks

 

[David Biddulph]

Select the series for which you wish to change the chart type, right-click,
select "Chart Type ...", select the relevant option.

 

[Dave]

Thanks

That works perfectly!

Select the series for which you wish to change the chart type, right-click,
select "Chart Type ...", select the relevant option.