Excel 2007 Pie chart

[Dannyh1]

Hi,

I have an Excel 2007 Pie chart created, which updates depending on what is selected from a dropdown menu.

For most of the of the selections made from the dropdown, the pie chart updates fine.

However, for 3 of my selections, the pie chart shows all as one colour, (the legend still shows different colours).

Has anyone come across this/know how to fix it?

Many Thanks.

 

[RoryA]

Do you have more than one value greater than 0 for those selections?

 

[Dannyh1]

Hi,

Yes - the values are showing in pie chart, for example:

one of my selections is split 68 / 37 but both sections are coloured purple.

The legend for the 68 is green & for 37 is red

Thanks.

 

[RoryA]

Can't say I've seen that - do you have SP2 installed?

 

[Dannyh1]

Sorry, not familiar with SP2 - what is it? (can it be downloaded free?)

Thanks.

 

[RoryA]

Office 2007 Service Pack 2. Free from MS and an absolute must-have as it fixes a lot of bugs.

 

[Dannyh1]

Thanks Rory, I'll give that a go.