« The redundant dimension eye-trick | Main | Concordance, or tag clouds »



In the bottom-most of the charts on the right, the one with the Y-axis rescaled... are you certain that the blue line got rescaled along with the axis?

The chart on the left suggests that whatever is being plotted along the Y-axis (giving the blue line) never exceeds approx. "175". Yet the bottom chart on the right has whatever is being plotted to produce the blue line roaring well beyond "200".

What am I missing?



I've responded to your cross-posted question over at YARG.. er... Flares. The second axis is not shown on the redrawn charts, but in the original there were two - one for the price of oil and one for capital expenditures.


Yup. My mistake, Morgan. I looked without reading even remotely carefully. My only defense, and a weak one it is, is that the second Y-axis against which the blue line is plotted should probably have been shown on the two graphs on the right.


Glad you figured it out. I should have said "rescaled the left axis" to make things more clear.

Jon Peltier

Wasn't until I read knucklehead's post that I realized the left axis was for the columns in the original chart. The fact that the blue line rose quickly and spent most of the time above (and to the left of) the columns gave the mistaken impression that it belonged to the left axis.

This illustrates my own conflict with dual axis charts: how to make it clear which axis accompanies which data, and how to display the series of data without one obscuring the other and without showing false interactions between the data.

Sanford Silverburg

Is it possible in Excel 2007, in order to graph clusters of widely dissimilar data, to have multiple scales on the Y-axis?
Please respond directly to my email. TIA.

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment

Your Information

(Name is required. Email address will not be displayed with the comment.)


Link to Principal Analytics Prep

See our curriculum, instructors. Apply.
Marketing analytics and data visualization expert. Author and Speaker. Currently at Columbia. See my full bio.

Book Blog

Link to junkcharts

Graphics design by Amanda Lee

The Read

Good Books

Keep in Touch

follow me on Twitter