Monthly Sales Data In Stacked Bar Chart

[Hatton Point]

Hi. I'm attempting to bind the attached data example to a Stacked Bar Chart and not having much luck using the example here:

http://demos.kendoui.com/dataviz/bar-charts/grouped-stacked-bar.html

The goal is to have Months on the X-axis and Product totals per month, each product stacked on the Y-axis. The example provided only show configuration for building using static data is a particular format. Is it possible to use the data sample attached without reorganizing?

Thanks.

[Dimiter Madjarov]

Hello,

 
If I understand you correctly, you want to have the products for each month stacked on top of each other. To achieve this, you could group the data by product name and then generate new series for each unique product. The Stack configuration must be set to true. For your convenience I've prepared a small sample project, showing the described approach.

I hope this will solve your problem.

Greetings,
Dimiter Madjarov
the Telerik team

[Hatton Point]

Thanks for the reply. However, your sample data set does not reflect the one I provided. I think the answer is the data needs to be in a different format. Not already grouped by Month. Once i have the data formatted as your example is, I will try it again.

[Dimiter Madjarov]

Hello,

Thanks for posting! If you need to adapt the chart to a slightly different data, feel free to modify the sample project to fit your needs.

Please keep me updated with your progress.

 

Kind regards,
Dimiter Madjarov
the Telerik team