|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 23rd, 2007, 01:40 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
How to create a table which calculates the angles in a Pie Chart?
I have a tally chart, a bar chart and a pie chart. How do I construct a
table which will calculate the angles in the pie chart ? 
|
|
#2
September 23rd, 2007, 11:06 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to create a table which calculates the angles in a Pie Chart?
Hi Lynne,
Values of Slices 3 5 6 4 9 === 27 (total) =3/27*360 and so on. The value of a slice divided by the total multiplied by 360. -- Cheers, Shane Devenshire "Lynne" wrote: I have a tally chart, a bar chart and a pie chart. How do I construct a table which will calculate the angles in the pie chart ?
|
|
#3
September 23rd, 2007, 11:12 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to create a table which calculates the angles in a Pie Cha
Thanks, yes I realised a little later that all I need do was show the
percentages and do the mathematics. Your help is appreciated. Ciao, Lynne "ShaneDevenshire" wrote: Hi Lynne, Values of Slices 3 5 6 4 9 === 27 (total) =3/27*360 and so on. The value of a slice divided by the total multiplied by 360. -- Cheers, Shane Devenshire "Lynne" wrote: I have a tally chart, a bar chart and a pie chart. How do I construct a table which will calculate the angles in the pie chart ?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
