J
JAM
Hello.
I am trying to create a pie chart with 10 labels each linked to a cell
of the same value, so the pie pieces are of a uniform size. I would
like to know if there is a way to color the pieces based on a
conditional data from other cells? Specifically I am wanting to colors
to be assigned in the following example:
Red if cell=1
yellow if cell>1,<4
Green if cell>=4, <=5
Example: lets say label 1 is linked to A1 which has the value of 3,
label 2 is linked to A2 which has a value of 4, and label 3 is linked
to A3 which has a value of 1. The labels would be colored Yellow,
Green, and Red respectively. The chart is to graphically represent the
Risk status of various functions based on the standard stop light
principle of Green = No Risk, Yellow = Medium Risk, and Red = High
Risk. Is this possible or is this totally the wrong approach. I am
pretty new at doing this type of charting in excel.
Thanks.
I am trying to create a pie chart with 10 labels each linked to a cell
of the same value, so the pie pieces are of a uniform size. I would
like to know if there is a way to color the pieces based on a
conditional data from other cells? Specifically I am wanting to colors
to be assigned in the following example:
Red if cell=1
yellow if cell>1,<4
Green if cell>=4, <=5
Example: lets say label 1 is linked to A1 which has the value of 3,
label 2 is linked to A2 which has a value of 4, and label 3 is linked
to A3 which has a value of 1. The labels would be colored Yellow,
Green, and Red respectively. The chart is to graphically represent the
Risk status of various functions based on the standard stop light
principle of Green = No Risk, Yellow = Medium Risk, and Red = High
Risk. Is this possible or is this totally the wrong approach. I am
pretty new at doing this type of charting in excel.
Thanks.