2 scale in a single chart

[Guest]

I have 2 scale one in thousand dollars and the other one in million dollars.
Is it possible to place the thousand scale in the left column and the million
scale on the right? However due to the huge differences. eg. the chart will
plot from 3 thousand to 10 milion, you will see a big gap there. Which make
the chart looks ugly.

If only I can change the million units inbetween the thousand units.

Can I change the different units in the right and left side of the scale?

 

[Tushar Mehta]

It is not clear what you want and where you are stuck.

Do you want to know how to create 2 series one shown on the primary (left)
axis, the other on the secondary (right) axis? If so, double-click the
series you want on the right and from the Axis tab select the Secondary
option.

I don't understand the bit about big gaps and changing the millions
inbetween the thousands bit.

Can the right and left axis be scaled differently? Yes. I don't know when
this was introduced but double-click the axis, then the Scale tab, then set
the 'Display Units' from the drop-down box.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions