Home > Forum Home > Charting and Performing Technical Analysis > Charting help needed! Share

Charting help needed!

Excel Help for Charting Help Needed! in Charting and Performing Technical Analysis

Forum TopicPost Reply Login

Charting Help Needed!

Rate this:
(3/5 from 1 vote)

I am trying to build a chart with to include the following type of data:

Excel Spreadsheet:
1 Test1 Male Female
2 Written 100 60
3 Passed 70 40
4 Failed 30 20
5 Test2  
6 Scheduled 150 100
7 Completed 75 60

Here's my problem. My table looks similar to this except I have about 7 different headings. (Test1, Test2, PEP1, PEP2, etc...) and in each of those headings I can have anywhere from 3 to 4 rows of data.

I am trying to compare the tests in a process. We are trying to find out where our students are failing in our process. I want to be able to display this in a chart, but I am not sure how.

Can anyone help? What chart type would be best to use? If I use a column chart, how do I get it to display the data in a way that makes sense?

 Posted by on
Replies - Displaying 1 to 2 of 2Order Replies By: Most Recent | Chronological | Highest Rated
Rate this:
(3/5 from 1 vote)
It really depends on exactly you want to show. If you want to show failure rates you should probably convert your data into percentages for each test.  You could also total the passed and failed for each gender and test and calculate the percentages on those.

One way to show the failure rate overall by gender and a break down by test would be to use a stacked column chart.  Here you could either have one column per test with the height of the column showing the overall failure rate with the breakdown of females and males, or two columns with one for males and one for females with the breakdown of each test within each column.

Alternatively, you could have two basic column charts with one for males and one for females showing the results for each test.  Here you chould also use a 100% stacked column showing the success and failure rates within each column for each test.
 Excel Business Forums Administrator
 Posted by on
Rate this:
(3/5 from 1 vote)
Great info provided.. Anyways thanks for sharing information..
 computer support service
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Charting help needed! in the