Creating a Chart Exhibit

Discover how to create a Chart Exhibit (Column, Pie and Line Charts).

Read this article to understand:

Creating a new Data Exhibit
Display options

Creating a new Data Exhibit

1. In Admin > Content > Dataviewer, select the Data set you'd like to use from the drop-down menu.

2. Click the New exhibit button.

3. Drag some data from Hidden to the appropriate ‘Rows’/’Columns’/'Values' boxes.

4. To turn this data into an exhibit, click Chart.

🔔 If the table data spans more than 1 page you will be unable to build a chart. Please use the filters to reduce the contents of the table.

5. Select the rows and columns that you would like to be represented in the exhibit. To make a chart, there should only be one option in the Value section.

chart_exhibit_1

6. Edit the title and chart type (column, line or pie) as required in Layout options.

7. Add descriptive data to the Chart Info box in the bottom-left.

chart_exhibit_2

You can also select to 'Include in data product' which will let users view this chart as part of the main data set.

8. Click Save current exhibit (far right).

chart_exhibit_5

🚨 Be aware that changing the data in the table may reduce the charting options.

Pie charts will only be available when one column is selected.

chart_exhibit_6

9. Once you are happy with the data and chart you will need to assign it a title within the Details area.

chart_exhibit_8

You can also complete the Display options for the chart. These differ between chart type.

Display Options

Column Chart

X-Axis Title - Allows you to add a name to the X-Axis.
Y-Axis Title - Allows you to add a name to the Y-Axis.
Display Type - If you have more than 1 data column to appear you have the option of Stacked or Clustered.
Show Grid Lines - Allows you to display the grid lines on the chart.
Scale from zero - Allows you to set the scale to start from zero.
Order by value - Allows you to order the columns by value (highest to lowest).

chart_exhibit_9

Bar Chart

X-Axis Title - Allows you to add a name to the X-Axis.
Y-Axis Title - Allows you to add a name to the Y-Axis.
Display Type - If you have more than 1 data column to appear you have the option of Stacked, 100% Stacked or Clustered.
Show Grid Lines - Allows you to display the grid lines on the chart.
Scale from zero - Allows you to set the scale to start from zero.
Order by value - Allows you to order the columns by value (highest to lowest).

Clustered/Stacked/100% Stacked

A clustered chart displays different data series within a category as separate columns/bars next to each other.

A stacked chart displays different data series within a category as parts of the same columns/bars.

A 100% stacked chart displays the percentage of each column/bar made up of each different data series.

Line Chart

X-Axis Title - Allows you to add a name to the X-Axis.
Y-Axis Title - Allows you to add a name to the Y-Axis.
Marker Style - Allows you to add a marker that will display on the line. You can choose between None, Circle, Cross or Diamond.
Line Style - Allows you to select the style of the line that displays. You can choose between Solid, Dash or Dot.
Show Grid Lines - Allows you to display the grid lines on the chart.
Scale from zero - Allows you to set the scale to start from zero.

Pie Chart

Display Type - This allows you to alter the type of pie chart. You can choose between Pie or Doughnut.
Label Position - You can select to have the labels appear on the outside of the pie or legend where they will appear below the pie chart.
Order by value - Orders segments by size going clockwise (highest to lowest).

Once you are happy with your chart, the view, the layout and have assigned it a title select Save current exhibit.