Multiple Data Sets

Not sure if this makes sense but is it possible to show various data sets on one graph? For example, I presently have a chart that shows P vs. A, this is projected vs. actual. I want to include efficiency on the same chart but it is in %, whereas the P vs. A is in regular numbers. So when I try to do it, efficiency shows at the bottom or zero. It is actually 120%+ but does not show. Is it possible to show % and regular numbers on the same chart?

Thanks.

"corona91719" <corona91719.24rq2y_1142522101.3184@excelforum-nospam.com>
wrote in message
news:corona91719.24rq2y_1142522101.3184@excelforum-nospam.com...
>
> Not sure if this makes sense but is it possible to show various data
> sets on one graph? For example, I presently have a chart that shows P
> vs. A, this is projected vs. actual. I want to include efficiency on
> the same chart but it is in %, whereas the P vs. A is in regular
> numbers. So when I try to do it, efficiency shows at the bottom or
> zero. It is actually 120%+ but does not show. Is it possible to show %
> and regular numbers on the same chart?

Select the second series, Format axis, and select "secondary axis".
--
David Biddulph