Using the Data 1 row, create a pie chart. Each row of data represents a pie chart you wish to create with 2 segments per pie chart.Ĭreate a named range by highlighting cells D3:E14 (the pie chart values) in your data table and then typing the new name “PieChartValues” in the name box. Columns D and E represent the pie chart values. Columns B and C represent the line chart data values. Imagine you have a data table like the one shown below. Well in essence the principle is the same. One I posted as an example in this post: 20 excel charts for your dashboards:Īnother was to create a line chart in combination with a bubble chart. Since then I’ve had a few requests for modifications. The post also shows you how to create a basic bubble pie chart: Create a bubble pie chart or world map pie chart using vba and Excel chartsĪlthough I wrote the how to, the original work was of course done by Andy Pope. Way back in February of 2013, I published a how to guide on how to create a world map pie chart using vba and Excel.

How to create pie chart in excel 2013