Skip to content
Yamuno
Browse

Data Sources

When you insert a chart, the editor first asks Where's your data? There are four answers.

Source Best for
Table on this page Charting a table people already keep on the page
Enter data A few numbers typed or pasted from a spreadsheet
Upload a file An export from another tool, as CSV, TSV or Excel
Jira issues Counting and summing Jira work items

Table on this page

The editor finds the tables already on the page. When there are some, this option is shown first with Found N tables, and the first table is picked for you.

  • The chart follows the table. When people edit the table, the chart changes with it.
  • Draft or published. While a page is being edited, the chart reads the draft. On a published page it reads the published version.
  • Moving things around is fine. The chart finds its table by the header row, so adding tables above it doesn't break it.
  • If the table is removed, the chart shows the last copy of the data it saved.
  • Re-read page refreshes the data from the page.
  • Blog posts work too.

The app reads text, mentions, status lozenges, dates and merged cells, and it finds tables inside layouts and expands.


Enter data

A small spreadsheet grid inside the editor.

  • Type into the cells, or paste a range copied from Excel or Google Sheets into any cell.
  • Fill with example puts in sample data to start from.
  • Sample CSV downloads a small example file that shows the expected shape.
  • Add or remove rows and columns as you go.

Upload a file

Pick a file from your computer:

  • Formats: CSV, TSV or Excel .xlsx. The older .xls format isn't supported; save it as .xlsx first.
  • Size: up to 5 MB and 5,000 rows.
  • Where it goes: the file is read in your browser and the data is saved with the chart. The file itself isn't uploaded anywhere.
  • Several sheets: if an Excel file has more than one sheet, the editor asks which one to use.
  • Replace file swaps in a new file.

After the upload, the data shows in the grid. Edits you make there change the chart, not the original file.


Jira issues

Chart work items from the Jira site connected to the same Atlassian site. Pick:

  • one or more projects,
  • a saved filter, or
  • a JQL query.

Drill-down: clicking a bar or slice opens those issues in Jira search.

Jira is optional. A site admin connects it. If Jira isn't connected:

  • the Jira issues option is greyed out in the editor,
  • existing Jira charts show "Jira isn't connected",
  • charts from the other three sources keep working.

Permissions: a viewer who doesn't have access to the Jira projects behind a chart sees a clear message instead of the chart.


Stuck on something this page does not cover? Ask the developers.