Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I show degrees in a Pie chart
could any one please help me, i need to display degrees in a pie chart and I
have not got a clue how this is done. |
#2
|
|||
|
|||
Hi!
A small example: worksheet has, starting in column A, Row 1.......a......b......c.....d Row 2 15...25....49....33 Put in A3 =360*A2/(SUM(A2:D2)) and copy across columns B...D This gives each column its share of 360 degrees Now select A1:D3 and use the chart wizard (button on toolbar or Insert Chart on the menu) and choose the first, simplest Pie chart offered. This should put a pie chart on your worksheet. Right-click on it and select Source Data and then the Series tab. Change the box labelled Category labels to read $A$3:$D$3. (These are the "degree figures you want) Finally, go to Chart Options (right-click on the chart) and choose the Data Labels tab. Have a play with all the various combinations of checkboxes there. Alf |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I show data under a Chart that I inserted in a worksheet? | Charts and Charting in Excel | |||
How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
How do I set my Excel Chart to not show areas where I have no dat. | Charts and Charting in Excel | |||
hide column but show chart | Charts and Charting in Excel | |||
On a scatter chart show two point have same value | Charts and Charting in Excel |