2 Replies Latest reply: Feb 19, 2013 8:49 AM by rajyalakshmig RSS

How to create a Bar Chart with multiple dimensions?

rajyalakshmig

Hi,

 

My data looks something like this (a sample):

 

CHEMICALSUPPLIER172.112.472.54
CHEMICALSUPPLIER182.692.332.02
CONSTRUCTIONSUPPLIER192.612.42.56
CONSTRUCTIONSUPPLIER22.882.862.87
CONSTRUCTIONSUPPLIER201.812.591.95
CONSTRUCTIONSUPPLIER211.831.892.82
CONSTRUCTIONSUPPLIER221.952.312.67
CONSTRUCTIONSUPPLIER231.922.512.27
CONSTRUCTIONSUPPLIER243.13.583.59
METALWORKINGSUPPLIER253.453.293.06
METALWORKINGSUPPLIER264.13.83.21
METALWORKINGSUPPLIER274.243.23.6

 

I need a barchart that shows by each industry (Chemical/ Construction/ Metalworking) the names of suppliers (Supplier1, Supplier2 etc.) and their respective scores for each year (column 3,4,5 in the above table).. I'm only able to add Supplier Name & the respective score against each name, however, I'm not able to include the Industry name in the same chart, as, when I do so, the chart automatically changes to stacked type, which is not what I need.

I'm attaching my QV file.. could anyone please help with this?

 

Thanks,

Rajyalakshmi