ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to create a table which calculates the angles in a Pie Chart? (https://www.excelbanter.com/charts-charting-excel/159363-how-create-table-calculates-angles-pie-chart.html)

Lynne

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 ?

ShaneDevenshire

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 ?


Lynne

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