Just like any chart, we can easily create a pie chart in Excel version 2013, 2010 or lower. Final result: Pie of pie chart How to create a pie chart? This chart makes the pie chart less complicated and easier to read.įigure 1. It is actually a double pie chart, which displays the parts of a whole through a main pie, while also providing a way to represent the minor slices through another pie. Not perfect: You end up without a proper legend but at least you have sensible labels in the right place.Excel has a built-in chart type called pie of pie chart. Right click on the inner doughnut, format data series, and reduce the hole to as small as possible. In Number, create a custom format "0% " (without the quotes) so that zero & negative values will be suppressed. Set this to show Category Name and Percentage. Right click on a single data point in the outer doughnut, and add data label. Insert a Doughnut chart, creating two series: Value (B2:B7), and Line Value (D2:D7). Remove the legend from the chart completely In column E, add a third column which gives blanks for unimportant data =IF(MATCH(C2,C:C,0)=ROW(),C2,"") In column D, add another column which summarises the data =IF(MATCH(C2,C:C,0)=ROW(),SUMIF(C:C,C2,B:B),0) In column C, add a calculated column which is to the right of your data table =LEFT(A2,LEN(A2)-1) (this will give you a high level category) I'd do pretty much the same as you have done.Īssuming your data exists in cells B2:B7.
(Ideally I would like to get rid of the small circle in the middle, but I can live with this if necessary). How can I get the legend to show Category A, B, C rather than Series 1 and 2? Either from this graph or using a completely different approach. This more or less creates the graph that I want, except that the legend now displays the two series rather than the category labels. I then swapped the series around and added data labels to the consolidated series with numbers formatted so that "0%" never shows:Īt this stage I then changed the name of categories X1 to just X and deleted the categories X2 so that the legend displays only the overall categories:įinally, I changed the central doughnut to a pie and made the hole as small as possible: I plotted both of these series on a doughnut chart, using a patterned fill to distinguish categories X2 from X1: I started by creating an extra column consolidating the data: I want to create a pie chart that reflect all of these segments, but apply % labels to just the overall categories A, B and C. I have found an approximate way of doing this - these are the steps I followed. I want to create a pie chart with data labels which refer to more than one segment.
0 kommentar(er)
