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>
