Wednesday, 7 August 2013

How to rotate pie diagram to a desired position in MS Excel

The structure of a pie chart depends on the pie chart style that you have selected and is rendered automatically. The data is represented in a clockwise direction. However, it is possible to change the direction of the pie chart. To do so, select the data in the pie chart and then right click on it. You will see an option called ‘Format Data Series’. Click on it and select ‘Series Option’. To change the direction of the pie chart, specify the degree of rotation in the ‘Angle of first Slice’ box. Depending on the degree of rotation you specify, Excel will rotate the pie chart.

No comments:

Post a Comment