Morning all,
I have an Excel 2003 problem that I am after some help with. I have a simple Pie chart that is formatted to display 11 equal segments. This will never change.
What I would like to do is allow staff to type in a percentage from 0 to 100% and based on some criteria change the segment colours on the pie chart without changing the segment size.
So, for instance if the percentage entered is 35% and the criteria for red was 0-40% then the associated segment would turn red.
There are three criteria using three colours.
Clear as mud I know!
I have the pie chart segmented and think the only way to do the rest will be using a VB Macro.
Can anybody help?
Thanks in advance.
Adam
I have an Excel 2003 problem that I am after some help with. I have a simple Pie chart that is formatted to display 11 equal segments. This will never change.
What I would like to do is allow staff to type in a percentage from 0 to 100% and based on some criteria change the segment colours on the pie chart without changing the segment size.
So, for instance if the percentage entered is 35% and the criteria for red was 0-40% then the associated segment would turn red.
There are three criteria using three colours.
Clear as mud I know!
I have the pie chart segmented and think the only way to do the rest will be using a VB Macro.
Can anybody help?
Thanks in advance.
Adam