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's Profile: http://www.excelforum.com/member.php...o&userid=32527
View this thread: http://www.excelforum.com/showthread...hreadid=523093

Multiple Data Sets
 

"corona91719"
wrote in message
...

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