Multi series from same dataset

[Jon]

Hi All,

I want to have a chart with 3 line series based on the data below where the first column is the series, the second is the x axis and the 3rd is the y axis value.

Can chart series be done like this yet?  If not is there any fudge with datasets that I can use to pull the data in?

Regards

Jon

2 2013-04-08  9
2 2013-04-09  2
2 2013-04-10  4
3 2013-04-07  2
6 2013-04-08  5
6 2013-04-09  6
6 2013-04-10  2

[Danail Vasilev]

Hi Jon,

In the current version of RadControls, the desired grouping functionality is not supported by the RadHtmlChart yet. However, such a feature request has already been logged as a PITS item here, so that you can monitor, comment or raise its priority by voting on it.

If you want to databind the RadHtmlChart to such a datasource, you need to recreate your current logic so that there are separated fields in the datasource that will be referenced by the DataField property of each Series, as it is shown in this online demo.

Kind regards,
Danail Vasilev
the Telerik team

[Jon]

Hi Danail,

Yes thanks for that - I'd managed to find this and get it working the alternate way :)

Regards

Jon

[Lidiya]

Hi all,

I have to display OrderDate in X axis . For each Date there is more than 1 series (total order made by customers for a product) and for each Customer their TotalOrderQuantity in y Axis. ie, Total Order made by customers on a particular Date.
How can I implement this in RadHtmlChart Stacked Column chart..

Please help me..


Regards,
Seena

[Danail Vasilev]

Hello Seena,

I suppose you are trying to put GrandTotal labels for the stacked series. If that is so, then please refer to the post from Apr 24, 2013 in this forum thread, that shed more light on the matter.

Regards,
Danail Vasilev
Telerik

[Lidiya]

Hi Danail,

Thank you for your response.
I had go through the link you provided. But, my requirment is not exactly like so.
I need to display Order Date in X Axis, Total Order Quantity in Y Axis...and in each Order Date there may be 1 or more customers (Series Names)...ie, total order made by customers on that particular date.

Please see the attached image similar to my requirement.

Regards,
Seena

[Danail Vasilev]

Hi Seena,

I have recreated the mentioned example, so that it illustrates how to create and add series with dynamic names to the chart programmatically. Please find it in the attached archive. If this examples does not fit in your scenario, could you please elaborate more into it, so that we can provide an accurate solution to you?

You can also find useful the HtmlChart - Programmatic Chart Creation and HtmlChart - Date Axis online demos.

Can I also ask you to not open different forum threads for the same questions, in order to avoid duplicate themess?

Regards,
Danail Vasilev
Telerik

[Lidiya]

Hi Danail,

Thanks for your help.
I had managed to create stacked chart with DataTable which has dynamic columns and data. :)
One more query...Is it possible to display the Series Name from database? In that case, Can we show Programatically added Color (in ColorField property) with this Series Name in Legend for Column Chart & Bubble Chart?

Since I was not able to reply for your post, I opend a different forum. Sorry...
This is my first attempt at starting a thread in a forum.

Thanks a lot for your support.

Regards,
Seena