Dual Vertical Axes Chart (US/TW patent obtained)
Dual vertical axes chart is commonly used in today’s data analysis and software, especially when comparing datasets with different units, to present the relation between two datasets in their original values, such as which dataset has increased more or less.
However, none of the software today has an algorithm which can equalize the elongation of the both vertical axes, which is decided by the respective top scale and bottom scale of the two vertical axes, to enable the chart to correctly present the relation of the lines, and thus the viewers are often misled.
- Excel adopts the same algorithm for single vertical axis chart when setting the scales of dual vertical axes chart, thus the elongations of both axes are not coordinated to be the same.
Nevertheless, Graphician patented algorithm provides a solution for this and by incorporating our scaling algorithm, chart creating software will be able to further improve the effects of visualization in the big data era.
Excel algorithm vs. Graphician algorithm
- Excel algorithm mispresents a decrease from 100 to -91 in magnitude is similar to a decrease from 100 to 94.
- Graphician algorithm shows a decrease from 100 to -91 in magnitude is much more than a decrease from 100 to 94.
Beside the real life application examples listed below, you may also use your own samples to test and see how the algorithm can present a correct dual vertical axes chart differently from other chart making software’s algorithm, by downloading our trial use Excel add-in below (the Excel version needs to be Excel 2007 or beyond) or contact us to convert your samples and test on below link.
Real life application examples of Graphician Dual Vertical Axes Chart
Case 1: Misled by chart – What drove the increase of sales?
| Period | Selling Price | Units Sold | Sales |
|---|---|---|---|
| Q1 | 84 | 9,762 | 820,000 |
| Q2 | 100 | 10,000 | 1,000,000 |
- Excel algorithm mistakenly presents as the selling price and units sold both increased, but there was no much increase on sales.
- Graphician algorithm correctly presents the fact that the main driver of increased sales is the increased selling price.
Case 2: Misled by chart – What drove the growth of number of employed labor?
- Excel cannot present any obvious relation between the 2 data sets.
- Graphician correctly shows the fact that in modern society, increase of employed in all industries has been mainly contributed by increase of employed in non-agricultural industries.
Case 3: Misled by chart – Which stock performed better?
- Microsoft’s share price grew 20.1% from the lowest to the top while Dell’s grew only 11.1%. However, the chart indicated that Dell’s price movement was much larger than Microsoft’s.
- Graphician shows the movement of the 2 stocks in same elongation and the fact that Microsoft’s share price performed better than Dell’s.