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.