Multi axes graphs are helpful when you want to compare related items with different scales. Multi axes graphs let you visualize data in the same analysis for multiple calculation types. Multi axes graphs are also known as multi-scale.
In this article
1. Multi Axes Graph
A multi axes graph is an effective way to show multiple calculation types on a single chart. This makes it simple for viewers to compare and understand the correlation between different calculations. As many as 10 calculation types can be included in a multi axes chart, but the resulting graph is difficult to read and more than four would not be recommended.
You can create a multi axes chart from a table that has several calculation types included in separate variables, or you can include one variable with several calculation types, for example in a standard axis with values. In the following examples, two calculation types are displayed.
Standard Axis with Values
When you create a crosstab using a standard axis with values, Harmoni automatically includes averages and numbers in the total row, and percentages in the element rows. To create a multi axes graph, you must first set the total to averages only and then create your graph. Follow these steps:
- Create the analysis table using a standard axis with values in the down dimension
- Select both calculation types in the Total row and replace with Averages (AVG)
- Deselect the row
- Visualize
- Use the Selector to add the Total row into the graph
- Click Multi Axes Graph
- Use the drop down arrow below the graph icon to adjust graph options per calculation type
In the example below, the Net Promoter Score axis with values is included in the down drop zone with Year in the across drop zone. Prior to visualizing, the analysis table has the Total row as averages and the rows as percentages.
- Create an analysis from a standard axis with values
- Adjust the Total row to show averages
- Visualize and select Multi Axes graph
- Add the Total using the Selector
- Use the drop-down menu to choose the chart type for each calculation type
- If required, adjust the min and/or max scale values
Standard Axis and Measure
In this example, the analysis table has two variables in the rows that each have different calculation types, and an observation group across the columns. Using the Net Promoter Score model, the NPS measure creates the average, while the NPS segments display as percentages.
- Create the analysis table using a standard axis and a measure in the down dimension
- Adding the measure changes the calculation type to averages, so you need to select the rows you want as percentages and change the calculation type
- Deselect the selected rows
- Visualize
- Click Multi Axes Graph
- Use the drop down arrow for the graph icon to adjust graph options per calculation type
In the table below, because only the element rows are graphed, you do not need to alter the calculation types in the Total rows. The elements display the calculation types required for the analysis.
- Create an analysis table with several calculation types
- Ensure the correct calculation types are displayed in the rows
- Visualize and select Multi Axes Graph
- Use the drop-down menu to choose the chart type for each calculation type
- If required, adjust the min and/or max scale values
2. Select the Graph Type
You can select different graph types for each item in your analysis; this can be at the axis or element level. Multi axes graph follows the rules of the chart types selected.
The types of graphs you can choose include:
- Bar graph
- Stacked bar graph
- Line graph and/or Trendline
- Solid line graph
- Dotted line graph
- Solid line graph
After accessing the drop-down menu for the Multi Axes Graph icon, click the calculation type and select the chart type required. Once selected, the chart icon is highlighted in orange.
3. Scale Controls for Multi Axes Graphs
You can choose to have your chart display automatic scales (let the system pick the best for the data presented), or you can apply logical maximum or minimum settings to each of the charts.
- Each calculation type has its own scale
- Click the calculation type
- Click the padlock next to Min or Max to access the input field
- Enter the value you require for the scale
- Press Enter
Where to from here?
Learn more about Visualize