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 th
low 100's. How can I graph both lines on the same chart? When I tr
to graph them as separate series the number trend basiclly lies on to
of the x axis. I'd like to be able to see both of them on the sam
graph

--
petevan
-----------------------------------------------------------------------
petevang's Profile: http://www.excelforum.com/member.php...fo&userid=2503
View this thread: http://www.excelforum.com/showthread.php?threadid=50680

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!!

--
petevan
-----------------------------------------------------------------------
petevang's Profile: http://www.excelforum.com/member.php...fo&userid=2503
View this thread: http://www.excelforum.com/showthread.php?threadid=50680