llkaimport.blogg.se

How can i make a pie chart in excel and combine segments
How can i make a pie chart in excel and combine segments











how can i make a pie chart in excel and combine segments

Long story short, the slice shape is not the same as the slice shapes that make up the original pie chart because of their extra “controls” table in the shape sheet which allows manually setting the thickness. So you can’t get more than ten slices using shape data, what next? The Pie Slice shape in the Graph and Math Shapes looks promising, maybe you can go into the shape sheet and bind couple of slice shapes together. Unfortunately, this glimmer of hope is shot down when you realize the chart just ignores any properties after the tenth one. At this point, if you know your way around Visio a little bit you might be tempted to right-click on the pie chart and go to Data–>Define Shape Data and try to alter the “slices” property and add more “Pie” properties, which is exactly what I did at first. Notice that Visio gives you the option of adding a maximum of ten slices. Lets start by creating a new basic Visio page and placing a regular pie chart on it, by going to More Shapes–> Business–> Charts and Graphs–> Chart Shapes. Once all the slices are added to the pie chart, each individual slice will be bound to external data, giving them a dynamic thickness. This is done using Visio 2013, but the steps using 20 should be very similar. This blog post will explain how to accomplish the seemingly easy task of adding over ten slices to a Visio pie chart.













How can i make a pie chart in excel and combine segments