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 ? |
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 ? |
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 ? |
All times are GMT +1. The time now is 02:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com