Variable or Split vertical axis scales

[Bone Daddy]

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?

 

[Wigi]

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]

I meant: Right click the chart series, choose Format data series... and then
in the Axis tab.

 

[Jon Peltier]

Here's an alternative approach. It's more work, but may be less confusing to
read than a chart with primary and secondary axes:

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

- Jon