How to link a Pie chart to column from database and show total of each of the same item in that column

Question

I am new to programming so sorry for the noob question. Ok so what i would like to do is the following, I have a form with a pie chart that I want to link to a database and have each section of the pie chart show data from a specific column and show the total number of the same items in that column. Example the Action, Drama, Animation for each of the section and then show the total number of each in that same column. I know how to link the database but unsure of the code for the example I gave. any help I thank you for! I also know the code would go between the While loop but not sure of the code

---

James franklin

Answer 1

Hi,

You need to add Series(ChartType is Pie) for Chart control and set XValueMember and YValueMembers property based on your column.

For example:

Private Sub Form1_Load(ByVal sender As System.Object, ByVal _
        e As System.EventArgs) Handles MyBase.Load
        Dim dt As New DataTable()
        dt.Columns.Add("Status")
        dt.Columns.Add("Total")

        dt.Rows.Add("Success", 34)
        dt.Rows.Add("Missing", 2)
        dt.Rows.Add("Failed", 10)

        Chart1.DataSource = dt
        Chart1.Series("Series1").XValueMember = "Status"
        Chart1.Series("Series1").YValueMembers = "Total"
        Chart1.DataBind()
    End Sub

Screenshot:

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 2

Thank you for the help. I just have one other question is it possible to also show the Count on the chart as well. for example have the 34, 2, & 10 show next to or somewhere for each section of the echart?

---

James franklin

Answer 3

Hi

Try this

Private Sub Form1_Load(ByVal sender As System.Object, ByVal _
        e As System.EventArgs) Handles MyBase.Load
        Dim dt As New DataTable()
        dt.Columns.Add("Status")
        dt.Columns.Add("Total")

        dt.Rows.Add("Success", 34)
        dt.Rows.Add("Missing", 2)
        dt.Rows.Add("Failed", 10)

        Chart1.DataSource = dt
        Chart1.Series("Series1").XValueMember = "Status"
        Chart1.Series("Series1").YValueMembers = "Total"
        Chart1.Series("Series1").Label = "#Total{N2}"
        Chart1.DataBind()
    End Sub

Ref

http://betterdashboards.wordpress.com/2009/02/04/display-percentages-on-a-pie-chart/

http://msdn.microsoft.com/en-us/library/dd489231(v=vs.110).aspx

---

Shridhar J Joshi Thanks a lot

Answer 4

Thank you for the help. I just have one other question is it possible to also show the Count on the chart as well. for example have the 34, 2, & 10 show next to or somewhere for each section of the echart?

---

James franklin

Sure, like this:

......
Chart1.DataSource = dt
Chart1.Series("Series1").XValueMember = "Status"
Chart1.Series("Series1").YValueMembers = "Total"
Chart1.Series("Series1").Label = "#AXISLABEL #VALY"
Chart1.DataBind()

Screenshot:

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.