Is the OP's problem though that it's a single point in a series that is out
of proportion with the rest. Rather than two series with different value
spreads.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jon Peltier" wrote in message
...
It depends on the chart type you've selected. If you've selected any of
the (unsavory) 3D flavors, you cannot mix chart types or axes. If you
stick with the 2D varieties you have a lot more flexibility.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"mwam423" wrote in message
...
hi jon, appreciate the response. i'm working in excel 2003 and when i
click
on the axes tab, secondary isn't an option. am i outta luck on this one?


"Jon Peltier" wrote:

Double click a series, on the Axis tab of the dialog select Secondary.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______