Colored Pie Chart

[dmitrybaron]

Greetings,

I'm attempting to create a pie chart with five evenly spaced slices, each one having their own label, but I also want to have the ability to show a slice in a color of my own choosing; green, yellow, and red. The file is uploaded to icloud, but I can also share it via email if needed.

The intent is to simply display an item of interest and report it's current status.

iCloud

Any help would be greatly appreciated.

 

[Jon Peltier]

Did you format the pie slices appropriately?

What are the formulas in the cells plotted in the pie? Note that I have just updated my post with the tutorial with a better formula for this range.

 

[dmitrybaron]

Sir, grey shows up orange.

 

[Jon Peltier]

Make sure the slices are formatted properly. Type 1 in column G. What does the chart look like?

 

[dmitrybaron]

Make sure the slices are formatted properly. Type 1 in column G. What does the chart look like?

 

[Jon Peltier]

You have to go around the pie and format the pieces using the list of colors in column E. Then put the formula back into column G.

 

[dmitrybaron]

I'm a dope. Thank you.

 

[Jon Peltier]

No, if you're like me, you got excited and left out a few steps.

 

[dmitrybaron]

Much appreciated Sir.