how to make a pie chart in excel with data

More operations about pie charts in Excel As the best alternative to Microsoft Excel, WPS Spreadsheet provides the users with over 100 built-in formulas, excel functions and more, and it supports images, audio, video and even Flash. WPS Spreadsheet is one of the powerful WPS Office suite, which is compatible with Microsoft Excel. Then, the layout of slices in the pie chart will change along with the order of source data. Click the Sort drop-down button and select the desired sorting method, for instance, Ascending here. 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.

How to make a pie chart in excel with data