Chartio allows you to create a dual y-axis Line chart with 2 or more lines. This document explains how to designate which lines correspond to which axis.
Start by creating your Line chart with multiple measures and 1 dimension as usual. In this example, we’ll compare the total MRR, total number of Seats, and count of distinct Documents uploaded per month using our “Document Company Demo Data” demo Data Source.
Once you’ve added the the correct values to your chart, click Run Query and click on the Line chart icon below the chart preview.
Open your chart’s settings by clicking on the Settings button located above the chart preview.
Switch to the Series tab and click the Dual Y-axis checkbox at the bottom of the tab.
An additional field will appear allowing you to customize the number of columns to be included on the right axis. We’ll enter a value by default here based on your query results but feel free to adjust as needed.
In this example, we want the last 2 columns to be on the right y-axis, so in the Last X Columns on right axis field, we’ll enter 2. The chart preview will automatically update with the new y-axis layout. If this looks correct, click Done after you’ve finished customizing your settings.
Note: If you want your first column(s) to be on the right axis, rearrange your measures in your query or add a Reorder Columns Pipeline Step in the Data Pipeline to move these columns all the way to the right (or to a lower position).
In our example, the Month of Started Paying Date is on the x-axis, the Total sum of MRR is on the left y-axis, and the Total sum of Seats and Count of distinct Documents Id are on the right y-axis.
You can then rename your columns or customize your axis labels as needed and save your chart once completed.