Hi
I have a bar chart with the highest value at the top gradually decreasing so the lowest value is at the bottom. I would like a smooth gradiant of colour across each bar from green to red at the bottom - indicated agents who are above tartget to agents who are below.
Does anyone know if this can be done in Excel? I am using version 2003 i think.
Thanks
Simon
I have a bar chart with the highest value at the top gradually decreasing so the lowest value is at the bottom. I would like a smooth gradiant of colour across each bar from green to red at the bottom - indicated agents who are above tartget to agents who are below.
Does anyone know if this can be done in Excel? I am using version 2003 i think.
Thanks
Simon