Select the range of data you want to sort, and head to the Data tab. In this table, for example, the source data is not sorted in ascending or descending order, thus the slices in the pie chart are not sorted in corresponding order.ġ. Normally, a pie chart is more visualized if the slices are sorted from the smallest to the largest. Alternatively, you can directly enter the number to rotate the pie. Select SERIES and you can adjust the Angle of first slice by dragging the slider to reorder the slices as needed. In the pane on the right, click the CHART OPTIONS drop-down button, and select Series 1. And we can alter the order of slices by rotating the chart for different perspectives.ġ. Generally, the order of slices in the pie chart correspond s to the order of source data. Steps to change the order of slices in pie chart in Excel. Click the image to creat e a 3D pie chart. In the pop-up dialog, click Pie and select the desired style, for example, a pie of 3D here. Select the range of data you'd like to put into the pie chart, and go to the Insert tab, click the Chart button.Ģ. And you can easily create a pie chart in WPS Spreadsheet following the steps:ġ. The source data illustrate s the percentages of various foods based on the recommended diet. Simple steps to create a pie table in WPS Office This tutorial from WPS Offical Academy helps you learn about how to reorder slices in the pie chart in WPS Spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |