(Solved) – Generate pie chart and retrieve data

(solved)-–-generate-pie-chart-and-retrieve-data

Background

Excel Worksheet:
Sheet1=”Class A”, Sheet2=”Class B”, Sheet3=”ClassC”
Column A=StudentID, Column B= Gender(M/F), Column C= Scores

I already generated a listbox1(“Class A”, “Class B”,”Class C”),listbox2(“M”,”F”), Piechart button, Retrieve data button

Things I want to do:
1)Select the listbox1 Value(e.g Class A) from listbox; Then Click the generate piechart button related to M/F (e.g M/F students in Class A)

2)Select listbox2 Value(e.g “M”); Then Click the retrieve data button( retrieve data of all “M” students from Class A

Leave a Reply

Your email address will not be published. Required fields are marked *