Formatting Pie Chart Colours according to value

pafranklin · May 30, 2009

[FONT=&quot]I have a simple spreadsheet file.[/FONT][FONT=&quot]
[/FONT]
[FONT=&quot] Basically there are a number of questions (in this case 9) and the answers to the questions can be either 1, 2 , 3 or 4. [/FONT][FONT=&quot]
[/FONT]
[FONT=&quot]I have produced a simple pie chart but would like to be able to format the pie chart segments according to the value of the answer. <o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]In other words if:
[/FONT]
[FONT=&quot]answer is 1 the segment needs to be green[/FONT]
[FONT=&quot]answer is 2 the segment needs to be yellow[/FONT]
[FONT=&quot]answer is 3 the segment needs to be amber[/FONT]
[FONT=&quot]answer is 4 the segment needs to be red[/FONT]

[FONT=&quot]I am not great at VBA so[/FONT] <link rel="File-List" href="file:///C:%5CUsers%5CPaul%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5CPaul%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5CPaul%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style> <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format

ther; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} @font-face {font-family:"Comic Sans MS"; panose-1:3 15 7 2 3 3 2 2 2 4; mso-font-charset:0; mso-generic-font-family:script; mso-font-pitch:variable; mso-font-signature:647 0 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Calibri","sans-serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; color:#003572;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt;} @page Section1 {size:612.0pt 792.0pt; margin:72.0pt 72.0pt 72.0pt 72.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} -->*</style>[FONT=&quot] please would you be able to advise how this could be accomplished?[/FONT]

file:///C:/Users/Paul/piechart1.xlsx
[FONT=&quot]<o

></o

>[/FONT]

Andy Pope · May 30, 2009

No need for any VBA coding. Here is an example I did recently that displays sections of a donut based on a RAG value.
http://www.andypope.info/ngs/ng60.htm

Bascially you need to increase the number of slices in your pie so there are 4 slices per question. 3 of the 4 slices will have a value of zero. This is controlled via formula. Then all you need to do is format the slices with required colours.

pafranklin · May 30, 2009

Hi Andy,

Thanks ever so much for the pointer and examples. This is really helpful and I will be having a crack at this over the weekend.
Best wishes and thanks again.

Paul

Formatting Pie Chart Colours according to value

pafranklin

New Member

Andy Pope

Active Member

pafranklin

New Member

Similar threads

Share this page

Formatting Pie Chart Colours according to value

pafranklin

New Member

Andy Pope

Active Member

pafranklin

New Member

Similar threads

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock