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: http://www.excelforum.com/member.php...o&userid=25034
View this thread: http://www.excelforum.com/showthread...hreadid=506802

Hi,

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:
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.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks so much for your help Andy. It looks great!!!


--
petevang
------------------------------------------------------------------------
petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034
View this thread: http://www.excelforum.com/showthread...hreadid=506802