software

I'm trying to graph a 2005 company trend showing dollars and numbers.
The dollar amount is in the millions and the number amount is in the
low 100's. How can I graph both lines on the same chart? When I try
to graph them as separate series the number trend basiclly lies on top
of the x axis. I'd like to be able to see both of them on the same
graph.--
petevang
------------------------------------------------------------------------
petevang's Profile: www.excelforum.com/member.php...oamp;userid=25034
View this thread: www.excelforum.com/showthread...hreadid=506802Hi,

Plot one of the lines on the secondary Y axis. To do this double click
one of the series and on the Axis tab of the Format Dialog choose
secondary axis.

Cheers
Andy

petevang wrote:
gt; I'm trying to graph a 2005 company trend showing dollars and numbers.
gt; The dollar amount is in the millions and the number amount is in the
gt; low 100's. How can I graph both lines on the same chart? When I try
gt; to graph them as separate series the number trend basiclly lies on top
gt; of the x axis. I'd like to be able to see both of them on the same
gt; graph.
gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info


Thanks so much for your help Andy. It looks great!!!--
petevang
------------------------------------------------------------------------
petevang's Profile: www.excelforum.com/member.php...oamp;userid=25034
View this thread: www.excelforum.com/showthread...hreadid=506802