archie1_za
New member
- Joined
- Sep 2, 2018
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010/2016
Good Day Excel Gurus
Im a newbie to the forum & hope someone would be kind enough to assist me.
I need to create a chart from the data in the attached spreadsheet
There are 32 rows of data but that will increase as time goes.
I need:
- Column A has text values "Success & Fail"
I need to count how many successes and how many fails and put this value in a column chart that will show side by side qty of successes & qty of failures as well as the total.
- The same for column B & C
- For column D I want to show the average % for Success & average % for Fail as well as the overall %
I would really appreciate any assistance.
I know a Excel a little and will be able to follow and manipulate formula's etc to a certain extent.
Thank You very much
Im a newbie to the forum & hope someone would be kind enough to assist me.
I need to create a chart from the data in the attached spreadsheet
There are 32 rows of data but that will increase as time goes.
I need:
- Column A has text values "Success & Fail"
I need to count how many successes and how many fails and put this value in a column chart that will show side by side qty of successes & qty of failures as well as the total.
- The same for column B & C
- For column D I want to show the average % for Success & average % for Fail as well as the overall %
I would really appreciate any assistance.
I know a Excel a little and will be able to follow and manipulate formula's etc to a certain extent.
Thank You very much