[acprc]

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