Click at the “ Total” half pie, then click it again to select this half pie. Click at the Legend Entry of Total, and then click it again to select it, then remove the Legend Entry of Total, see screenshots:ģ. Select all the data range and click Insert > Pie > Pie. And sometimes, you may want to create a half pie and excluding the series “total”, now I will tell you how to solve it in Excel.įor example, you have a range of data as shown as below, and now creating a half pie excluding total.ġ. Sometimes, if you have a data range with total data, when you insert a pie chart to show these data, one half of pie is the series “total”, another half is the other point values as shown as below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |