tip 09 – how to make a 2-axis chart

tip 09 – how to make a 2-axis chart
level: easy

Sometimes you want to combine two values in one chart that have a completely different size range. If plotted against the same y-axis, one of the values will disappear as it is too low to become visible. The solution for this is a double-axes chart.

This video will show you how to make such a chart in icCube. It starts of with the chart created in tip 08.

It’s an “up-tempo” video, you might want to pause a couple of times if you want to study the steps.

Timeline and topics:

  • As always, it start with the end-result: a 2-axis chart, with a sales amount (left axis) and an orders amount (right axis);
  • As starting point, the chart from tip 08 is used;
  • First add the additional measure “Internet Order Quantity” in the data layer;
  • then, change the chart to a combo-chart “Columns and Line”;
  • update the Value definitions and let the charts use the measures from the data layer;
  • create two new value axes, one for “Internet Sales” and one for the “Nr of Orders”;
  • note that the first gets the id “left” and the 2nd gets “right”;
  • now, for the column graph, assign the Value Axis id “left”, and the line graph “right”;
  • the result is a double-axes chart, with the axes to the left;
  • place the ” right” access to the right;
  • change the numeric formatting to display amounts as thousands or millions;
  • change the appearance of the line, to show bullets;
  • change the balloon text to show the correct information;
  • add a chart header;
  • save, verify that it works;
  • place the report in the application (tip 07) and you’re done.

Back to dashboard tips.