Table formatting for Bar, Line, and Area charts

Charts

Bar, Area, and Line charts all accept a similar table format. Here’s a brief explanation on the types of table formats these charts accept, along with chart examples.

Two columns

One measure grouped by one dimension

Chart, one measure & two dimensions

  • First column maps to x-axis.
  • Second column maps to y-axis.

Sample table

Table, one measure & two dimensions

One measure grouped by two dimensions

Chart, one measure & two dimensions

  • Add a Pivot step, which allows the second column’s values to each become a new column. View an example of a Pivot here.
  • First column maps to x-axis.
  • After the Pivot, subsequent columns map to the y-axis and are grouped and labeled by their column name.

Sample table (before Pivot step)

Table (before Pivot), one measure & two dimensions

Sample table (after Pivot step)

Table (after Pivot), one measure & two dimensions

Multiple measures grouped by one dimension

Chart, multiple measures & one dimension

  • First column maps to x-axis.
  • Subsequent columns are mapped to the y-axis, and are grouped and labeled by their column name.
  • Tooltip displays second through last column on hover.

Sample table

Table, multiple measures & one dimension


Related Charts Help Articles

See more