Wednesday, January 18, 2017

A Two Axis Combo Chart for Data with Very Different Ranges

Aus die Meister Hal Graycar. Say one series is interest rate - sub 10 and the other is principal - tens to 100's of thousands.

Start off with the plain-jain line chart - you'll see the interest rate line hugging the X-axis.

Right-click on "Interest rate" at the bottom and choose Format Data Series.

In the new tab on the right, choose the checkbox for Secondary Axis.

You'll see that you get a 2nd Y-Axis on the right.

.... uhh... actually, all that stuff is from 10 years ago. Now, you have the Combo chart which comes with a menu.. so Harold has upgraded :)

No comments: