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
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Robert Mika

MrExcel MVP
Joined
Jun 29, 2009
Messages
7,256
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
 

shivam03

Board Regular
Joined
Nov 22, 2010
Messages
86
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.
 

Robert Mika

MrExcel MVP
Joined
Jun 29, 2009
Messages
7,256
This is my current set up and everyting works well:
What am I missing?
74355414.jpg
 

shivam03

Board Regular
Joined
Nov 22, 2010
Messages
86

ADVERTISEMENT

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
 

Robert Mika

MrExcel MVP
Joined
Jun 29, 2009
Messages
7,256
You can not insert picture directly you need to use external site.
I uses Panoramio bit there are more of them just google it.
 

shivam03

Board Regular
Joined
Nov 22, 2010
Messages
86

ADVERTISEMENT

Hi,

Okay thanks.

Your pie charts looks fine.

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

shivam03

Board Regular
Joined
Nov 22, 2010
Messages
86
Thanks for your help. The only way to get it to work was to recreate the graph.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,499
Messages
5,596,517
Members
414,074
Latest member
Matthew Kakde

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
Top