Hi,

I'm trying to generate a column chart (as image below) by using entity(as image below) that has Identifier column in Text Format (basically like a matrix).

Issue that I faced :

1. On Import Excel file, it didn't import all the data from excel and return some blank values
2. The chart that I need as per image below, I can only get 1 column, but as you can see the required chart has two columns and one line chart with a table format legend below it. 

Column Chart I need : 

What I got :

My chart returned no value.
What I tried :

I had to manually type the label text as I didn't retrieve the column names (or is it possible).

Entity :

I imported excel file, but it didn't import all the values. (excel file for reference below entity).