Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
995
ColumnChart and Data Grouping
posted

I'm trying to achieve something with the UltraWebChart but just can't seem to get the data to appear as I need.

I have a DataTable with 3 columns as shown below:

Year     Product     SalesCount

France Product1        3

France Product2        6

France Product3        9

Itally      Product5       7

Itally      Product6       3

Itally      Product7       8

Spain      Product10       7

Spain      Product11       12

Spain      Product12       9

 

What I'm trying to achieve is a column chart with the data grouped into Country and separated by the products. VERY IMPORTANT is that the products for each country are different.

 I have been trying to do it in a lots of different way but I was alaways unsuccesful.

Thanks in advance for any advise.