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]

First of all, be careful with your choice of colors: Red and Green are indistinguishable to around 8% of your male audience. Some kind of blue-yellow-orange would be better.

Second, what you can do is have three pie wedges per 1/5 of the circle, one of each color. Of these three wedges, the one you want to appear has value 1, the others zero.

Here's the data for the pie, with three wedges for each letter from A through E, one wedge of each color. Temporarily the values in the Pie column are all 1, so I can see all wedges to format them. And here are the blue-yellow-orange colors I suggested, which are all in the standard Office 2013+ color scheme,

New here's the broader worksheet. I have set up a range to the left that shows which color I want each letter to appear. And I have replaced the column of ones with formulas. When you change the color names in C3:C7, the chart will update.

Here are the first few formulas, you can figure out the rest:
G3: =IF(C$3=E3,1,NA())
G4: =IF(C$3=E4,1,NA())
G5: =IF(C$3=E5,1,NA())
G6: =IF(C$4=E6,1,NA())
G7: =IF(C$4=E7,1,NA())
etc.

UPDATE:

A better set of formulas for column G:

In cell G3, enter this formula:
=IF(INDEX($C$3:$C$7,MATCH(F3,$B$3:$B$7,0))=E3,1,NA())

Copy it down as far as needed (G3:G17 in this example).

 

[dmitrybaron]

Sir,

Thanks for the reply. I'll get working on this right away and let you know how it goes.

V/r

Dmitry

 

[dmitrybaron]

It worked beautifully. Much appreciated.

 

[Jon Peltier]

Glad I could help.

 

[dmitrybaron]

Jon,

I'm back. This time I'm trying to add a fourth color, gray.

 

[Jon Peltier]

You have three entries for HN and five for TESTS. Did you start with all 1's in the Pie column, so you could color the pie slices correctly?

 

[dmitrybaron]

Fixed that and made sure the pie slices are equal in size. However, the color 'gray' doesn't show. Must not be in the palate.

 

[Jon Peltier]

Chart Format tab > Shape Fill (middle of the ribbon). Gray is in the top row of the default Office color scheme. Or pick a color tile from the first column.

 

[dmitrybaron]

How do I trigger the color change with just simply typing ‘Gray’ in the cell? I can do that with the other three colors.