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