| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create a chart from a dynamic table of data? | Charts and Charting in Excel | |||
| How do I create a formula that calculates shipping costs? | New Users to Excel | |||
| How do I create a formula that calculates shipping costs? | New Users to Excel | |||
| How do I create a combination chart and table with different data. | Charts and Charting in Excel | |||
| create a timesheet that calculates hours per person per day and to | Excel Worksheet Functions | |||
Hybrid Mode
