acemanhattan
New Member
- Joined
- May 11, 2016
- Messages
- 45
I have the following Data where A,B,and C are Unique Groups with, for example, group A meeting the benchmark in 0% of areas, meeting the threshold in 63% of the areas, and below threshold in 38% of areas.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Benchmark[/TD]
[TD]0%[/TD]
[TD]50%[/TD]
[TD]22%[/TD]
[/TR]
[TR]
[TD]Threshold[/TD]
[TD]63%[/TD]
[TD]25%[/TD]
[TD]67%[/TD]
[/TR]
[TR]
[TD]Below[/TD]
[TD]38%
[/TD]
[TD]25%[/TD]
[TD]11%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
</tbody>[/TABLE]
What I want is for the vertical axis to display percentage, and for the horizontal axis to cluster each group with a column for each of Benchmark, Threshold and Below. So in the data above A would have a column for Threshold and Benchmark and group C would have a column for Benchmark, Threshold, and Below.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Benchmark[/TD]
[TD]0%[/TD]
[TD]50%[/TD]
[TD]22%[/TD]
[/TR]
[TR]
[TD]Threshold[/TD]
[TD]63%[/TD]
[TD]25%[/TD]
[TD]67%[/TD]
[/TR]
[TR]
[TD]Below[/TD]
[TD]38%
[/TD]
[TD]25%[/TD]
[TD]11%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
</tbody>[/TABLE]
What I want is for the vertical axis to display percentage, and for the horizontal axis to cluster each group with a column for each of Benchmark, Threshold and Below. So in the data above A would have a column for Threshold and Benchmark and group C would have a column for Benchmark, Threshold, and Below.