Renewed Report Builder: Column chart

Add a Column Chart widget to your customized report to show respondents' results at a glance. This is a great way of displaying data because it is easy to compare the columns.


   Professional         
   Enterprise         
   ReportR     
   DistributR     

This guide will teach you:

  1. Add a column chart
  2. Setup the widget
  3. Additional settings
  4. Additional buttons

1. Add a column chart

To add a column chart to the page, all you have to do is click on it and drag and drop it on the page. 

Column chart- add a column chart

If you would like to create columns and split your content in more widgets, then first you would need to select the number of columns you want.


You can find all the different column formats at the layout widgets.

Column chart- layout widgets

Then you can drag and drop the column widget on your page and add the widget in the column. 

Column chart- add a column chart

Once you add the widget a pop-up window will open where you can add your content.

2. Setup the widget

1.1  Create a single column chart

1.2  Create a multi-column chart


You need three elements to build your graph: Dimension Group label, Dimension Labels, and Metrics.

  • Dimension group labels are the names given to the sets of results along the horizontal axis. These could be, for example, different topics of a subject.
  • Dimension labels are the description of each category and are shown in the legend underneath the graph. These could be "Employee A" and "Average Score"
  • The metrics are the numerical data in each dimension. This would usually be a score, either picked from one of the survey variables, or a set value.

Before we move to the next step, you'll have to decide what type of graph you would like to use. A single column, where you present each respondent's score in a column or you can use a multi-column to compare scores with a benchmark.

Column chart- Column chart items

1.1 Create a single column chart

Column chart- create a single column chart

If you choose to create a graph similar to this example, you don't need to create any dimension groups. Instead, you can immediately start with the Dimension Labels and Metrics.

Column chart- create a single column chart

  1. Dimension Label - give a name to the column. This name will be shown in the key under the graph.
  2. Dimension Color - choose the column color by clicking on the color selector. Take care to choose distinctly different colors for each of the columns so the graph will be easy to read.
  3. Dimension Metric - choose where the data for the first column of the graph should be taken from. You can either type in a number or click Variables to access the drop-down menu of variables that you can use. Variables take the data entered during the survey and display it in the graph.
  4. Add dimension - click to add another column and repeat the steps above. To create the graph in the example, we created four dimensions in total.
note
NOTE


If you change your variable data, you must collect a new response in order to preview your graph.




tip
TIP


You can also add negative values into your dimension metrics as shown below.



Column chart- example with negative values

1.2 Create a multi-column chart
Column chart- create a multi- column chart

Start by adding dimension groups, which correspond to each set of columns.  In our example, we created six dimension groups in total, one for each subject.


Click Add group to add the number of dimension groups you need, and label each one.

Column chart- add group

Next click Add dimension to start creating the axes for your data points. Start your graph by clicking Add dimension.
Column chart- setup the chart

  1. Dimension Label - give a name to the column. This name will be shown in the key under the graph.
  2. Dimension Color - choose the column color by clicking on the color selector. Take care to choose distinctly different colors for each of the columns so the graph will be easy to read.
  3. Dimension Metric - choose where the data for the first column of the graph should be taken from. You can either type in a number or click Variables to access the drop-down menu of variables that you can use. Variables take the data entered during the survey and display it in the graph. Ideally, you should have as many Dimension Metrics as you have Dimension Groups. In this case, each value stands for a score. The value for Metric 1 matches with Group 1, in this case, Math. In total, we added four metrics, one for each dimension group (which corresponds to a different school subject).
  4. Add dimension- click to add a second data value for each dimension group. You can use this to compare respondents' answers to a benchmark.

In the example shown above, the class average was the second data value for each column, and we entered a number rather than a variable. But you can do anything you want!
Column chart- setup the chart


note
NOTE


Make sure the number of dimension groups matches the number of data metrics. Dimension group 1 is the name for all of the columns shown under dimension metric 1 and dimension group 2 is all of dimension metric 2 values.




Now you've set up your graph, you can also configure the y-axis and add the chart title.Column chart- axis

  • Y-Axis scale interval - choose the interval spacing for gridlines marking the vertical axis. Make sure you have a few to make the graph easy to read.
  • Y-Axis max - until which value do you want your y-axis to display? Enter it here.

In our example above, which shows values as percentages, the maximum value is 100, and gridlines are shown at an interval of 20.


Don't forget to click Save and close to save your changes and see your chart!

3. Additional settings

Select the widget and then at the right of the screen click on the gear button. The widget list will be replaced by the additional settings.

Column chart- additional settings

Here you can find the following settings:

  1. ID
  2. Name
  3. Rules
  4. Margins
  5. Background color
  6. Chart settings 

1. ID

This is the ID of the widget.

Column chart- id

2. Name

You can name your widget in order to identify it easier.

Column chart- name

3. Rules

You can add your widget logic rules to ensure that your content will be visible only when the conditions are true. 

Column chart- rules

When you click the Edit rule button a new pop-up window will appear.

Column chart- add logic rules

Select from the dropdown menu the option you want, and then fill in all the required fields. Once you add everything you can click the Submit button.

Column chart- submit button

Your content will not be displayed on the page anymore, instead of the content you will be able to see the widget logic rules.

Column chart- rules

If you would like to edit your content again just click on the rule and the widget will expand. To edit the rule you would have to click on the Edit rule at the settings.

Column chart- edit rule

This is the window where you can delete the rule by clicking on the Delete rule button.

Column chart- delete rule

4. Margins

Add margins to create space around elements and move them in your page. By default the margins are set to 0, but you can change that anytime and add the margin you prefer.

Column chart- margins

tip
TIP


You can add margins left and right to make your chart smaller. The bigger the margins, the smaller the chart. Note that the margins should be equal, in order for the chart to be centered in the page. 



5. Background color

You can change the background color of this specific widget by clicking the color selector.

Column chart- background color

Once you click it the background color selector will expand and you will be able to select the color you want or add the color hex.

Column chart- background color

To save just click Apply color.

6. Chart settings

You can change the default title and label font size if you want. This is very useful if you are placing your chart inside a column, or you adjust its size. In this case you will have a smaller chart but your text will still be readable.

Spider chart- chart settings

4. Additional buttons

When you click on your widget 4, blue buttons appear to the right.

Column chart- additional buttons

The Arrow allows you to move between the different layers of the page. For example if you add a widget in a column then you have 3 layers: the page, the column and the widget. The arrow allows you to quickly select a different layer.


The second icon, the four arrow sign, allows you to move your widget up or down to the page.

Column chart- additional buttons

The third icon, the page, allows you to copy this widget and the forth icon, the bin, to delete it.

What's next?

  • Renewed Report Builder-Bar chart: Add a Bar Chart widget to your customized report to show respondents' results or another data set at a glance. This way you will display your data with rectangular bars. It allows you to show data separated into categories with relative numbers.
  • Renewed Report Builder-Gauge chart: Add a gauge chart to your personalized PDF report to represent average or actual scores or percentage results for question blocks or formulas. Respondents can see at a glance if they've scored towards the top-end or bottom-end of the scale. It  allows you to display a large data set visually.
  • Renewed Report Builder-Spider chart: A spider chart is a great graphic way to compare results from different questions and visualize performance, for example between school subjects or departments of a business. You can include as many axes as you want, but the most visually appealing and clear would be between three and six axes.
S
Support is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.