Charlie1957
New Member
- Joined
- Nov 12, 2016
- Messages
- 8
HI all:
I need to create a pie chart using the data from thiscolumn- see below. I set it up so any values under 0% are in yellow (will bemost common), 0% cells are in green, and cells with more than 0% are in red. I need the pie chart to show just the % of each of the 3 colors and not all 115items in the column.<o></o>
Is there a way to do this?. Think I may need to create apivot table?<o></o>
<o> </o>
Thanks a lot,<o></o>
Charlie<o></o>
<o> </o>
<tbody>
</tbody>
I need to create a pie chart using the data from thiscolumn- see below. I set it up so any values under 0% are in yellow (will bemost common), 0% cells are in green, and cells with more than 0% are in red. I need the pie chart to show just the % of each of the 3 colors and not all 115items in the column.<o></o>
Is there a way to do this?. Think I may need to create apivot table?<o></o>
<o> </o>
Thanks a lot,<o></o>
Charlie<o></o>
<o> </o>
% Diff.: Act vs. Est.<o></o> |
-56.9%<o></o> |
-29.4%<o></o> |
-51.0%<o></o> |
293.8%<o></o> |
-100.0%<o></o> |
-72.6%<o></o> |
N/A for FY16<o></o> |
-48.6%<o></o> |
182.4%<o></o> |
-15.6%<o></o> |
-11.7%<o></o> |
-37.0%<o></o> |
-48.6%<o></o> |
-13.6%<o></o> |
-45.0%<o></o> |
-52.9%<o></o> |
-100.0%<o></o> |
-100.0%<o></o> |
0.0%<o></o> |
0.0%<o></o> |
-100.0%<o></o> |
-100.0%<o></o> |
0.0%<o></o> |
-100.0%<o></o> |
-50.0%<o></o> |
-50.0%<o></o> |
-50.0%<o></o> |
140.0%<o></o> |
-48.1%<o></o> |
-100.0%<o></o> |
-97.0%<o></o> |
-70.0%<o></o> |
10.0%<o></o> |
-46.0%<o></o> |
2754.0%<o></o> |
50.0%<o></o> |
-68.0%<o></o> |
-44.4%<o></o> |
-58.2%<o></o> |
-50.0%<o></o> |
22.0%<o></o> |
-13.2%<o></o> |
-41.7%<o></o> |
-41.7%<o></o> |
-94.4%<o></o> |
-98.0%<o></o> |
-98.0%<o></o> |
-69.9%<o></o> |
-76.0%<o></o> |
-87.2%<o></o> |
-64.6%<o></o> |
-85.5%<o></o> |
-41.7%<o></o> |
-54.8%<o></o> |
-20.0%<o></o> |
45.5%<o></o> |
-50.8%<o></o> |
-49.3%<o></o> |
-100.0%<o></o> |
-73.3%<o></o> |
-45.6%<o></o> |
-66.7%<o></o> |
-31.8%<o></o> |
1.0%<o></o> |
-20.9%<o></o> |
-74.0%<o></o> |
703.3%<o></o> |
-8.3%<o></o> |
200.0%<o></o> |
95.8%<o></o> |
-49.2%<o></o> |
-84.9%<o></o> |
-7.7%<o></o> |
-59.7%<o></o> |
-17.1%<o></o> |
36.8%<o></o> |
-24.3%<o></o> |
-35.0%<o></o> |
-63.8%<o></o> |
-58.5%<o></o> |
-27.6%<o></o> |
-39.9%<o></o> |
-29.9%<o></o> |
-60.7%<o></o> |
3.1%<o></o> |
90.7%<o></o> |
12.3%<o></o> |
-25.0%<o></o> |
-60.0%<o></o> |
-8.3%<o></o> |
-58.3%<o></o> |
-100.0%<o></o> |
-47.4%<o></o> |
-84.4%<o></o> |
16.9%<o></o> |
23.3%<o></o> |
0.0%<o></o> |
0.0%<o></o> |
0.0%<o></o> |
0.0%<o></o> |
-50.0%<o></o> |
-50.0%<o></o> |
-50.0%<o></o> |
-50.0%<o></o> |
-50.0%<o></o> |
-50.0%<o></o> |
-50.0%<o></o> |
-50.0%<o></o> |
100.0%<o></o> |
-56.6%<o></o> |
0.0%<o></o> |
40.7%<o></o> |
-32.1%<o></o> |
<o></o> |
-75.0%<o></o> |
-100.0%<o></o> |
-100.0%<o></o> |
4.9%<o></o> |
-83.3%<o></o> |
</tbody>