You could plot a series on a second vertical axis.
Right click the chart series, choose options and in one of the tabs you can
indicate this.
--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music
"Bone Daddy" wrote:
I'm charting figures that have about 5 numbers ranging from 1 million to 4
million and then the other dozen are all bunched together under half a
million. Is it possible to have two vertical scales? for instance the
initial scale from zero to half a million by units of $50,000 and then after
$500,000, the scale goes from 1 million to 4 million in half million
increments?