View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default 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 ?