How to add 2 X values on bar chart column on visual studio(using toolbox)

See more:

VB

Visual-Studio

Hai .

I would like to know how to add 2 X values on bar column on Visual Studio( I'm using chart toolbox to do the bar chart). Lets say I have this set of data:

----------------------------------
source |Loan Status         |Total
-------|--------------------|-----
AMBIT  |OVERDUE AND MATURED |205
AMBIT  |CLOSED	            |125
AMBIT  |BEING DRAWN         |341
AMBIT  |DRAWN               |637
EXCEL  |PERFORMING          |118

I want the Source and Loan Status Column on X axis while Total Column on y axis. The output that I desire is like this http://www.exceldashboardtemplates.com/wp-content/uploads/2014/02/image_thumb3.png[^]

Updated:

I already tried the solution from this link Need help of X-axis field display[^] and it worked ( The first answer is the output that I want). But this example shows the data must be manually inserted. If I want to make data binding with select SQL statement, what should I do?

What I have tried:

What I have been tried is

<asp:SqlDataSource ID="SqlDataSource36" runat="server" ConnectionString="<%$ ConnectionStrings:CRMConnectionString %>" SelectCommand="SELECT source, loanSts AS [Loan Status], COUNT(loanSts) AS Total FROM Loan WHERE (source IS NOT NULL)  GROUP BY source, loanSts">
<series>
   <asp:Series Name="Loan Status" XValueMember="Loan Status" ChartArea="ChartArea1" Legend="Legend1" YValueMembers="Total">
                         <asp:Series Name="source" XValueMember="source" ChartArea="ChartArea1" ChartType="Line" Legend="Legend1" YValueMembers="Total">
                    <chartareas>
                        <asp:ChartArea Name="ChartArea1">

The result of the output is on X-Axis shows Source column while Y axis shows Total column but with 2 series (series 1-Loan Status column, series 2- Source column).