Display multiple metrics with dual axis charts

There are cases when I need to display two metrics on one single graph; the matter gets complicated if the two have very different values, such as an absolute number and a percentage, or—generally speaking—when the values of one metric fall in a range different from the values of the other. We have seen that most of the times the numbers are displayed as series on the Y axis; so we have a minimum number and a maximum number on the left vertical margin of the graph (Y1). If the second metric has minimum and maximum values that do not fall into the first metric range, we can create a second Y axis and have the new minimum and maximum values displayed on the right margin of the chart (Y2). Let's see it with a practical example. We want to picture the sales amount from the resellers and the real product margin that each category of products has scored. We know from the previous chapters that we lost money on Bikes…

Getting ready

Create a new report...