Data Tables

Data tables in Excel provide the structure for Chartnado to use when designing widgets. These tables allow Chartnado to use column names instead of range references for arguments and values, for example.

Working with Excel ranges

One of the many good things about Excel is that it's very flexible. However, because it's so flexible it means it's hard for data analysis tools to understand the structure of data.

Cell ranges are unstructured

Because of the unstructured nature of the data, it's hard for Excel pivot tables and/or Chartnado to understand how to aggregate the data.

Create an Excel Data Table

The solution to this is to create an Excel data table. Data tables provide column headers that allow data visualization tools to understand the structure of your data.

Select Format As Table

On the Home ribbon tab, select Format As Table

(click on the image to see a larger version)

Choose A Color Format

All data tables have the same structure. You can choose any color format that works with the rest of your design style.

My Table Has Headers

Ensure the selection is checked to let Excel know that the first row in your range is the column headers to use for the table.

Column Headers

A new data table has been created with column headers.

Table Rows

The rows for the data table are now clearly identified.