Chart 2 axis
 

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

Chart 2 axis
 

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

"Dave" wrote in message
...
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

Chart 2 axis
 

Thanks

That works perfectly!


"David Biddulph" wrote:

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

"Dave" wrote in message
...
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