Hello everyone,
I have one requirement in my CRM website regarding charts in asp.net using c# using MSSQL server 2008 as backend.
Actually i am making a CRM website in which i want to show complaints status zone wise in charts.
The actual scenario:
What i have is 4 zones namely : North, east, west and south.
and complaint status as Closed,Pending,No-reply and partially closed.
Now by using queries i get the result as
Zone Pending Closed No-reply Partially Closed
North 1 3 0 4
East 5 3 0 2
.... .... ... .... ....
Now in chart i want to show on Y-axis the zone name and on x-axis the complaints count i.e pending count, closed count, no-reply count, partially closed count.
I have bind Y-axis of charts to zone but how do i bind the 4 complaint status count to x-axis , please suggest...
Thanks & Regards,
Krunal Panchal