software

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: www.excelforum.com/member.php...oamp;userid=32527
View this thread: www.excelforum.com/showthread...hreadid=523093quot;corona91719quot; gt;
wrote in message
...
gt;
gt; Not sure if this makes sense but is it possible to show various data
gt; sets on one graph? For example, I presently have a chart that shows P
gt; vs. A, this is projected vs. actual. I want to include efficiency on
gt; the same chart but it is in %, whereas the P vs. A is in regular
gt; numbers. So when I try to do it, efficiency shows at the bottom or
gt; zero. It is actually 120% but does not show. Is it possible to show %
gt; and regular numbers on the same chart?

Select the second series, Format axis, and select quot;secondary axisquot;.
--
David Biddulph