Display entries from different colmuns in bar chart

[Krexx]

Hello, i would like to display different columns in bar chart
For example for this table: 

Price	Category1	Category2
100	Shirt	Jeans
200	Shirt	Jacket
300	Shirt	Shoes

The bar chart should like then like this: 

When i use both colmns in the bar chart, i can only expand to the next level. 

Any ideas?

Thanks in advance

[ryan_mayu · Accepted solution]

@Krexx 

select price column and unpivot other columns in pq

then you can get the expcected output