Add a linked data table to a WordPress chart

A chart helps readers see a pattern. A data table lets them check the values behind it. If you publish a report in WordPress, keeping those two views together can save readers from estimating bar heights or searching a paragraph for a number.

ChartQuill includes a separate Chart Data Table block that connects to a chart in the same post. You can place the table where it is useful in the article, and its linked snapshot stays synchronised when you change the chart data. The basic chart and table workflow described here is available in ChartQuill Free.

Start with a small, clearly labelled dataset

Consider a report comparing support requests received by email and chat. The following figures are fictional, and are included only to demonstrate the publishing workflow:

Quarter,Channel,Requests
Q1,Email,38
Q1,Chat,29
Q2,Email,42
Q2,Chat,45
Q3,Email,47
Q3,Chat,65

The chart can show how the relationship changes between quarters. The table can answer a more specific question, such as how many chat requests were recorded in Q2. Both views should use the same definition of a request and the same reporting period.

For your own report, remove any columns that should not be public before entering the data. Check customer names, email addresses and internal notes as well as the numeric fields. A useful visual does not require publishing every field from the original spreadsheet.

Create the chart and explain its meaning

Open ChartQuill in the WordPress editor and choose a grouped bar chart. In Edit chart data, paste the rows above or import a local CSV file. Review the grid, then choose Apply data. Map Quarter to the category field, Requests to the value field and Channel to the series field.

Give the chart a descriptive title such as “Support requests by channel”. Add a summary that explains the comparison: “Chat requests overtook email in Q2 and widened the gap in Q3.” Label the measure as requests and identify the source as fictional example data. When you replace the figures, update the written summary and source as well.

A summary has a different job from a title. It should communicate the main observation in a sentence someone can understand without seeing the chart. Avoid making readers depend on colour or a hover tooltip to discover the point of the report.

Insert the linked table

Select the chart, open its chart reference controls and choose Insert linked data table. ChartQuill adds a separate Chart Data Table block connected to that chart. You can then move the table within the post using the normal WordPress block controls.

You can also insert a Chart Data Table block directly. If the post contains one tagged chart, it can connect automatically. Where there are several charts, choose the matching chart tag. Readable tags help distinguish, for example, the support-channel chart from a separate response-time chart in the same report.

Check the connection status before continuing. A table beside the right chart should also contain the right rows. In this example, it should show six rows, with 45 in the Q2 Chat row and 65 in the Q3 Chat row.

Put the table where readers need it

For a short article, placing the table directly below the chart makes the connection easy to follow. A longer report may work better with a chart beside the discussion and the table in a later reference section. Keep the caption specific enough for a reader to recognise the dataset in either location.

Use clear column names and state the unit where it could be ambiguous. “Requests” and “Completion rate (%)” tell readers more than “Value”. If the table contains a date range, category labels or a comparison period, make their meaning explicit in the caption or surrounding text.

Free includes Minimal, Grid and Striped table styles. Start with the treatment that makes the rows easiest to read in your theme. Pro adds Editorial and Report styles for different publishing layouts. You can compare the live table examples before choosing a presentation.

Check an update before publishing

In your draft, change one value in the chart’s data editor and apply it. Confirm that the linked table reflects the change, then restore the original value if you were only testing the connection. This is a useful check when a post contains several charts or you have moved blocks around.

Preview the public page at a narrow width as well as on a desktop screen. Read the headings, caption and all of the table’s columns. Check that the chart summary still agrees with the figures and that the table remains understandable without relying on a colour key.

ChartQuill saves a table snapshot, so the table can remain available if its source chart is removed. That is useful for a table-only layout, but it also makes checking the connection worthwhile when you later revise the post. Do not assume a retained table will follow a different chart merely because you place them together.

The ChartQuill setup guide covers the chart, content and connection controls. For branded reporting layouts and additional chart types, see the ChartQuill Free and Pro comparison.

Filed under: