Charting help needed!

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

Find Excel Solutions


Search Forums:
Recent Activity:
Web Query
Vba Save To Skydrive
Auto-timing Not Working Properly
"runtime Error 13" And "runtime Error -2147483640" Excel 2011 Mac
Portfolio Performance Monitoring And Valuation
Importing Data From Pdf Files




Follow Business Spreadsheets On:
 
Forum TopicReply Login

Charting Help Needed!

Rate this:
(3/5 from 1 vote)
ConfusedHi,

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


Excel Spreadsheet:
 ABC
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?

Thanks!
 Tayoub
 Posted by on
 
Replies - Displaying 1 to 2 of 2Order Replies By: Most Recent | Chronological | Highest Rated
Surprised
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
Confused
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

 

Find Excel templates
and add-ins in the
Excel Business Solutions Directory
   
  © 2014 Business Spreadsheets. All Rights Reserved. Legal |