Variable or Split vertical axis scales

  • Thread starter Thread starter Bone Daddy
  • Start date Start date
B

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?
 
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.
 
I meant: Right click the chart series, choose Format data series... and then
in the Axis tab.
 
Back
Top