Hi all,
I have a query which calculates the 'health' status of a system e.g.
Red: 15%
Yellow: 35%
Green: 50%
This is used to plot a pie chart.
I manually changed the Pie Slices color to match the health description. I.e. The Red Slice will be Red, etc.
When changes are made to the system, hence affecting the health for example, Red: 0. In the Pie Chart I will have only 2 Pie Slices, which is fine...however, this messes up the colors of the Slices and they are assigned some other random colors
I have been looking but could not fine out how to assign each slice a specified color via vb.
Thanks in advance
babou
I have a query which calculates the 'health' status of a system e.g.
Red: 15%
Yellow: 35%
Green: 50%
This is used to plot a pie chart.
I manually changed the Pie Slices color to match the health description. I.e. The Red Slice will be Red, etc.
When changes are made to the system, hence affecting the health for example, Red: 0. In the Pie Chart I will have only 2 Pie Slices, which is fine...however, this messes up the colors of the Slices and they are assigned some other random colors
I have been looking but could not fine out how to assign each slice a specified color via vb.
Thanks in advance
babou