Bar chart flip X and Y axis


I am binding data shown in the GridView the chart shown in the same image.
I need to change the display to a vertical column chart.
Is it possible to just flip the X and Y axes?
How else would I achieve this

SELECT Categories.[Main Category] + ' ' + Answers.Survey  As [Main Category], Round(sum((CAST([Score] as Float))), 2) AS Score FROM Answers LEFT JOIN Categories ON Answers.Category = Categories.ID GROUP BY Categories.[Main Category], Answers.Survey, Answers.ReviewerID, Answers.CompanyID HAVING (((Answers.Survey)='1') AND ((Answers.ReviewerID)='R') AND ((Answers.CompanyID)='XYZ')) Order By [Main Category] DESC

<asp:Chart ID="Chart_Total" runat="server" Height="336px" Width="348px">
                                        <asp:Title Text="">
                                        <asp:Series BorderWidth="5" ChartArea="MainChartArea" ChartType="Bar"
                                            Color="#000024" Name="MyCategories" YValuesPerPoint="6">
                                        <asp:ChartArea Name="MainChartArea">
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
Rahul AgarwalConnect With a Mentor Team LeaderCommented:
Just change

myChart.Series["mySeries"].ChartType = SeriesChartType.Bar;


myChart.Series["mySeries"].ChartType = SeriesChartType.Column;
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Great answer. Thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.