Can someone provide an example of how to change the colors of a pie chart? (The actual pie chart pieces). The pieces are referred to as Points? I'd like to choose a color using RGB for each piece. Thanks!
Change the pie chart colors
microsoft excelvba
Related Solutions
You'll first need to count the number of male and female entries, then make a pie chart out of that data.
In OpenOffice.org Calc I was able to use the COUNTIF function to count the entries, then select the counts and make a pie chart from that. It should be similar in Excel.
This is how I do it:
Add a column and fill it with 1 (name it Count for example)
Select your data (both columns) and create a Pivot Table: On the Insert tab click on the PivotTable | Pivot Table (you can create it on the same worksheet or on a new sheet)
On the PivotTable Field List drag Country to Row Labels and Count to Values if Excel doesn't automatically
Now select the pivot table data and create your pie chart as usual.
P.S. I use the pivot table for I update the data on a regular basis, then I just replace the "Country" data and refresh the pivot table.
Best Answer
Personally Peltier's Chart Blog is my favorite Excel Charting source. So take a look at some of the samples he discussed there. To know more here is the MVP
I do not think it's wonderful to copy his codes here. So try the tutorials stated in above materials out and comment if you have further questions. And here is some facts I thought would be helpful in your Charting Journey to be smooth and fun.
To be very specific on
RGB Colourformatting of yourpie chartslices, here is the code line:E.g.
You may find
RGBcolour numbers fromMS Paintapplication in Windows :) Else here is an article that shows some colours and correspondingRGBnumbers.As colour spectrum is infinite, it should be good enough to colour your extra multi sliced
pie chart, you may think.. HOWEVER don't forget that Excel default colour Palette has 56 colour indices. Like Excel 2003. So sometimes there are issues when using your Chart file in a different version of Excel - where you find some colours are missing and just being replaced by unappealing old looking colours ;)E.g. A Chart created in Excel 2007 and above has rich graphical, colour experience to the user. However Excel 2003 doesn't provide so, but manageable (and extremely great in performance though.) In Excel 2007 and later, workbooks can support millions of colors, but there is still an underlying workbook palette that has 56 colors.
So when you face such issues or be read to deal with it, plesae check on this article: