| 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 Topic | Post Reply Login |
Charting Help Needed! | Rate this: (3/5 from 1 vote) |
 | Hi, I am trying to build a chart with to include the following type of data: Excel Spreadsheet:
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 Tayoub on | ||||||||||||||||||||||||||||||||||
| Replies - Displaying 1 to 2 of 2 | Order Replies By: Most Recent | Chronological | Highest Rated |
 | Rate this: (3/5 from 1 vote) 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 Excel Helper on |
| Rate this: (3/5 from 1 vote) |
| computer support service | |
| Posted by Caldwell6 on |
| Displaying page 1 of 1 |
| Find relevant Excel templates and add-ins for Charting help needed! in the Excel Business Solutions Directory |