How To Add a Line to a Column Chart
By adding a line to a column chart, you can add context to make your visualization more compelling and better display the relationship between two related concepts. For instance, you may want to show a Top 2 box alongside NPS or a count of respondents next to an average rank. Even if your data is on different scales, you can do this in just a few clicks in Displayr!
For my example, I am going to take a simple column chart showing the percentage of respondents eating Burger Shack in the previous month and overlay a line for the average number of times those respondents ate Burger Shack during the same time period.
You will need to have a column chart created using Insert > Visualization > Column Chart. In the column chart below, I am showing the percentage of respondents who ate Burger Shack during the previous month. To learn how to create a column chart, click here.
Adding the line
To add a line to your column chart:
- Create a table for the data you want to show in your line overlay. Make sure your x-axis variable is in the rows. Below, I have a table showing the average number of times respondents ate at Burger Shack during the previous month.
- Click on the column visualization and select the table from step 1 under Inputs > DATA SOURCE - SECOND Y AXIS > Output in 'Pages'.
You will see the line show up over-top of your columns on the graph. You can then use the Chart menu in the Object Inspector to further customize your visualization.