Re: Comparative Graph

shahappsheet · 02-25-2022 06:22 AM

Hi Guys! Hope you are doing well. There are two months data can be found below. Is it possible to draw a comparative graph for the two months as I have shown a sample graph below the data.

Thanks and regards.

1/11/2022	1100
1/11/2022	35
1/11/2022	570
1/12/2022	25.8
1/12/2022	350
1/12/2022	61.69
1/12/2022	255
1/13/2022	24
1/13/2022	40
1/15/2022	53
1/15/2022	326
1/13/2022	10
1/15/2022	14.55
1/15/2022	5.9
1/15/2022	20
1/15/2022	22
1/15/2022	86
1/15/2022	52.95
1/16/2022	99.55
1/18/2022	60.6
1/18/2022	22.35
1/18/2022	81.8
1/19/2022	5
1/19/2022	19.75
1/19/2022	4.7
1/20/2022	27
1/21/2022	275
1/22/2022	31.6
1/22/2022	95.45
1/22/2022	54.8
1/22/2022	11.6
1/22/2022	39
1/22/2022	78.2
1/22/2022	17
1/23/2022	48.8
1/23/2022	85.24
1/23/2022	72.2
1/23/2022	26.84
1/23/2022	58
1/25/2022	10
1/26/2022	92.2
1/26/2022	10
2/20/2022	0
2/1/2022	28
2/5/2022	61.88
2/6/2022	60.4
2/12/2022	63.46
2/12/2022	5
2/12/2022	13
2/12/2022	4
2/12/2022	35
2/12/2022	28.2
2/12/2022	166.15
2/12/2022	187
2/14/2022	320.9
2/14/2022	100
2/22/2022	58.5

SkrOYC

With that data, impossible. I don't see where the second item to compare is

shahappsheet

Thanks for the reply. Then can you suggest how to reorganize those data to reach the target.

Regards.

shahappsheet

I converted the date into day and the amounts data I reorganized into separate columns. But legacy chart doesn't accept the days(numeric) as its major axis for the line chart. So far I could went through.

Thanks.

SkrOYC

You have just one column for date and another for who knows what data. How could you imagine any system whould be able to make two lines?

I mean, seriously, I'm curious of what you expect in order to help you

shahappsheet

Actually, I could advance to a point close to my target but not exactly what I want. You can see I could draw a comparative (not exactly as I want) line chart after reorganizing the data showed previously. But here the problem is that all the dates are coming on the horizontal axis. Actually i want the charts superimposed not horizontally side by side as it is in the current state.