Tuesday, October 13, 2015

Dual-Axis Chart - One Handy Solution

Here’s the result of an Excel add-in developed by Graphician.com by which the user can apply the company’s proprietary algorithm to adjust any dual-vertical-axis chart created by Excel 2010 (or later) with a single click. The purpose of the adjustment, as described in the preceding post on this topic, is to scale the plots proportionally to promote more accurate visual comparisons.

Examples on the left show how the Graphician add-in for Excel scales Y-axes proportionally to promote more accurate visual comparisons between the plots.
For more information, including a sample Excel file you can use to test the algorithm, go to www.graphician.com.

Perils and pitfalls of dual-axis displays are covered in Chapter 11: Viewports and Dashboard Displays of How to Lie with Charts - Investor's (Third) Edition.

2 comments:

  1. I think creating chart by your own it's wasting time. You can download them from http://www.pptstar.com/powerpoint/medical/ this is proven website without any malware. Try to and I'm sure you'll like it.

    ReplyDelete
  2. Templates may be fine and save time. One of the significant points of the book is that any automated solution brings the programmer's assumptions. These may or may not serve the purpose of the chart you are making. So use programmatic tools but always - always - challenge the results!

    ReplyDelete