Multiple Line Charts in Same Graph

[prvnsainiMember]

Hi,

We need to create a line chart with following type of data. Chart will have ‘result’ as Y axis (Val Axis) and ‘observation date’ as X axis (Category Axis). Each ‘Graph Series Name’ will create separate line with different color.

Please let us know if this is possible using jqwidgets.

Please consider below as sample data. In real scenario we may have 12000 such rows with 20+ different graph series.

ObservationDate	Result	GraphSeriesName
6/28/2013 17:42	98.1	Temperature
6/28/2013 20:06	97.7	Temperature
6/29/2013 0:11	97.8	Temperature
6/28/2013 17:16	18	Respiration
6/28/2013 17:42	16	Respiration
6/28/2013 20:06	18	Respiration
6/28/2013 17:42	82	Pulse
6/28/2013 20:06	108	Pulse
6/29/2013 0:11	89	Pulse
6/28/2013 17:42	100	O2 Sat
6/28/2013 20:06	95	O2 Sat
6/29/2013 0:11	95	O2 Sat
7/2/2013 4:00	50	PTT
7/18/2013 3:55	34	PTT
8/6/2013 6:15	43	PTT
6/28/2013 14:29	2.7	Creatinine
6/28/2013 13:41	104.2	Weight
6/29/2013 21:59	96.7	Weight
6/29/2013 22:32	96.7	Weight
7/1/2013 6:37	111.8	Weight
7/2/2013 5:42	117.8	Weight
6/28/2013 14:29	12.1	Hemoglobin
6/29/2013 18:23	14.4	Hemoglobin
6/30/2013 1:07	8.8	Hemoglobin
6/30/2013 2:58	8.6	Hemoglobin
6/30/2013 8:50	8.6	Hemoglobin
6/28/2013 14:29	33.3	Hematocrit
6/29/2013 18:23	40.6	Hematocrit
6/30/2013 1:07	26	Hematocrit
6/28/2013 14:29	248	Platelets
6/29/2013 18:23	472	Platelets
6/30/2013 2:58	375	Platelets
6/30/2013 8:50	402	Platelets
7/1/2013 4:00	137	Platelets
7/2/2013 4:00	116	Platelets
6/28/2013 14:29	1.2	INR
6/29/2013 6:27	1.3	INR
6/30/2013 2:58	1.7	INR
7/2/2013 4:00	2.3	INR
7/3/2013 4:15	1.9	INR
7/15/2013 18:00	1.3	INR
8/6/2013 6:15	1.5	INR
8/8/2013 5:45	1.6	INR
6/29/2013 8:00	5	Pain Management
6/29/2013 21:20	8	Pain Management
7/3/2013 12:24	0	Pain Management
7/5/2013 15:15	0	Pain Management
7/6/2013 13:17	0	Pain Management
6/28/2013 14:29	128	Sodium
6/29/2013 6:27	134	Sodium
6/28/2013 14:29	4.1	Potassium
6/29/2013 6:27	4	Potassium
6/29/2013 18:23	4.1	Potassium
6/30/2013 2:58	4.2	Potassium
6/28/2013 17:42	56	BP – Diastolic
6/28/2013 20:06	69	BP – Diastolic
6/29/2013 0:11	66	BP – Diastolic
6/28/2013 17:42	87	BP – Systolic
6/28/2013 20:06	106	BP – Systolic
6/29/2013 0:11	100	BP – Systolic
6/29/2013 3:59	104	BP – Systolic

Thanks

Praveen

[DimitarParticipant]

Hello Praveen,

Yes, it is possible to plot such a chart. Please take a look at the demo Stacked Line Series for a similar scenario.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[prvnsainiMember]

Thanks for you response Dimitar.

In Stacked Line Series, we have static months as X Axis and for each month we have data for ‘Referral’, ‘SearchPaid’, ‘SearchNonPaid’. I am taking reference of the DEMO specified in the site.

In our scenario, values in the x axis will be dynamic. It can be any date\time. Now there will be a series corresponding to each Graph Series (Refer to GraphSeriesName). First Series will be for ‘Temperature’. 2nd will be for ‘Respiration’ etc.

For example, below will be table for first series.

ObservationDate Result
6/28/2013 17:42 98.1
6/28/2013 20:06 97.7
6/29/2013 0:11 97.8

below will be table for 2nd series.

ObservationDate Result
6/28/2013 17:16 18
6/28/2013 17:42 16
6/28/2013 20:06 18

I like to attach a screenshot. But I am unable to find any option to attach screenshot.

Regards

[DimitarParticipant]

Hi Praveen,

You can upload an image at an image hosting website and give a direct link to it here. Please also clarify the issue you are experiencing (if any).

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[prvnsainiMember]

Hi,

We changed our default table. Now we converted that to below table. But we are not able to generate continuous line for NULL values in between. For example, in temperature column, two values are null between 98.1 and 97.7. Can you please help us to create a continuous line for below table?

ObservationDate Temperature Respiration Pulse O2 Sat PTT

6/28/2013 17:16 18
6/28/2013 17:41 100
6/28/2013 17:42 16
6/28/2013 17:44 98.1
6/28/2013 17:47 82
6/28/2013 20:01 108
6/28/2013 20:06 97.7
6/28/2013 20:08 18
6/28/2013 20:09 95
6/29/2013 0:11 97.8
6/29/2013 0:15 89
6/29/2013 21:01 109
6/30/2013 0:11 99.9
6/30/2013 18:05 110
7/2/2013 4:00 50
7/6/2013 8:00 50
7/18/2013 3:35 34
7/18/2013 3:55 34
8/6/2013 0:15 43
8/6/2013 6:15 43

[DimitarParticipant]

Hi prvnsaini,

If a data point value is null, the line is not plotted at that point. This behaviour cannot be altered.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[AadithanMember]

Hi Dimitar

In Microsoft Excel we have an option Show Empty Cell as a) zero b) Gab and c) “Connect Data Points With Line”. Do we have any similar
option in JQWidget chart ?

Regards

Aadithan

[prvnsainiMember]

Dimitar,

Can you please respond to below question along with Aadithan question? We both are working on same topic.

Can we assign multiple data sources to line chart graph? Can we created multiple Series Groups and assign multiple data sources to each of them?

Thanks.

[DimitarParticipant]

Hello,

Aadithan, there is no such jqxChart option, unfortunately.

Praveen, while having multiple series groups is possible, it is not possible to assign them multiple data sources, because the chart itself can have only one source assigned to it.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[gduarteParticipant]

Hello,
is there an option to plot a variable number of series?
Like, I have a dataset that can vary the number of series and I’d like to plot a variable number of series in each line. How to vary the number of series dynamically?

Cheers

[DimitarParticipant]

Hello gduarte,

Please check out the forum topic changing data series to see how to add chart series dynamically.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[Author]

Posts