View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Graphing Question

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