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
Is there a way to do this?. Think I may need to create apivot table?<o
<o
Thanks a lot,<o
Charlie<o
<o
% Diff.: Act vs. Est.<o |
-56.9%<o |
-29.4%<o |
-51.0%<o |
293.8%<o |
-100.0%<o |
-72.6%<o |
N/A for FY16<o |
-48.6%<o |
182.4%<o |
-15.6%<o |
-11.7%<o |
-37.0%<o |
-48.6%<o |
-13.6%<o |
-45.0%<o |
-52.9%<o |
-100.0%<o |
-100.0%<o |
0.0%<o |
0.0%<o |
-100.0%<o |
-100.0%<o |
0.0%<o |
-100.0%<o |
-50.0%<o |
-50.0%<o |
-50.0%<o |
140.0%<o |
-48.1%<o |
-100.0%<o |
-97.0%<o |
-70.0%<o |
10.0%<o |
-46.0%<o |
2754.0%<o |
50.0%<o |
-68.0%<o |
-44.4%<o |
-58.2%<o |
-50.0%<o |
22.0%<o |
-13.2%<o |
-41.7%<o |
-41.7%<o |
-94.4%<o |
-98.0%<o |
-98.0%<o |
-69.9%<o |
-76.0%<o |
-87.2%<o |
-64.6%<o |
-85.5%<o |
-41.7%<o |
-54.8%<o |
-20.0%<o |
45.5%<o |
-50.8%<o |
-49.3%<o |
-100.0%<o |
-73.3%<o |
-45.6%<o |
-66.7%<o |
-31.8%<o |
1.0%<o |
-20.9%<o |
-74.0%<o |
703.3%<o |
-8.3%<o |
200.0%<o |
95.8%<o |
-49.2%<o |
-84.9%<o |
-7.7%<o |
-59.7%<o |
-17.1%<o |
36.8%<o |
-24.3%<o |
-35.0%<o |
-63.8%<o |
-58.5%<o |
-27.6%<o |
-39.9%<o |
-29.9%<o |
-60.7%<o |
3.1%<o |
90.7%<o |
12.3%<o |
-25.0%<o |
-60.0%<o |
-8.3%<o |
-58.3%<o |
-100.0%<o |
-47.4%<o |
-84.4%<o |
16.9%<o |
23.3%<o |
0.0%<o |
0.0%<o |
0.0%<o |
0.0%<o |
-50.0%<o |
-50.0%<o |
-50.0%<o |
-50.0%<o |
-50.0%<o |
-50.0%<o |
-50.0%<o |
-50.0%<o |
100.0%<o |
-56.6%<o |
0.0%<o |
40.7%<o |
-32.1%<o |
<o |
-75.0%<o |
-100.0%<o |
-100.0%<o |
4.9%<o |
-83.3%<o |
</tbody>