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
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.
A new data table has been created with column headers.
The rows for the data table are now clearly identified.