Wrong colour showing in a pie chart

shivam03

Board Regular
Joined
Nov 22, 2010
Messages
86
Hi,

I have created a simple pie chart based on a table. I have changed the colours to reflect my own colurs.

Closed</SPAN>Red</SPAN>Amber</SPAN>Green</SPAN>
1</SPAN>0</SPAN>4</SPAN>0</SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=4></COLGROUP>

Closed is blue and amber is yellow.

The pie chart shows closed as red with the current data. However, for any value above one is shows the correct colour of blue.

Can anyone suggest what is happening here?

Thanks a lot.

Shiv
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
If Amber is Yellow how are you getting blues for any value >1?
With your data set up I have got Blue for closed, yellow for amber and nothing for Red and Green
 
Upvote 0
I have the following setup:

Bluie for Closed
Green for Green
Yellow for Amber
Red for Red

The colours seem to be fine for most combinations. The problem is when you have 1 closed and about 4 that are amber. (It can be a few more than 4.)

So in the example above 4 are shown as yellow and one as red.

When you increase the amber more than 1, the red changes to blue.
 
Upvote 0
This is my current set up and everyting works well:
What am I missing?
74355414.jpg
 
Upvote 0
Hi,

I can show you a screen shot but how did you get an image to show?

When I go to insert image, it asks for a URL.

Thanks
 
Upvote 0
You can not insert picture directly you need to use external site.
I uses Panoramio bit there are more of them just google it.
 
Upvote 0
Hi,

Okay thanks.

Your pie charts looks fine.

Can you try with the counts in the table above and see if it works please.
 
Upvote 0

Forum statistics

Threads
1,214,889
Messages
6,122,097
Members
449,065
Latest member
albertocarrillom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top