I didn't consider that. Shane mentioned two series, and I assumed that's
what the OP wanted. That's not necessarily true.

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


"Andy Pope" wrote in message
...
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
_______