Hi all,
From the query, the data is coming in rows as
Category date value

1 feb-1 1

1 feb-2 2

2 feb-1 2

2 feb-2 3

3 feb-1 1

3 feb-2 2

4 feb-1 2

4 feb-2 1

Date on X-Axis and value on Y-Axis.
I want to create line graph. The line graph has to be such that
1) There are four categories, it shows 4 lines (indicating each category) with value for each date.
Problem is that the all the categories are in rows, not in columns.
How to draw different lines for different categories?
Can anyone please help on this.
Thank you
Regards,
Prankur Pahuja