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

Manipulate the data

Excel Help for Manipulate The Data in Charting and Performing Technical Analysis


Forum TopicLogin

Manipulate The Data

Rate this:
(3/5 from 1 vote)
SurprisedIt 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
 
View Full Post

Excel templates and solutions matched for Manipulate the data:

Solutions: Integrate Data Collaboration Tool