Doing so would further divide each pie into the entries across the columns. Ideally, a pie chart isn’t the best option for those dealing with multiple columns.
Make a chart with data spread across multiple columns in Excel The chart will appear similar to the pie chart of your Excel sheet, but the values would probably be mentioned inside the pies. Click on Insert > Other Charts > Hierarchical > Sunburst.Ī larger view of the hierarchical sunburst chart is as follows:.Select the data across the 2 columns in question.Similar is the case for a hierarchical sunburst chart.In case you select data across more than 2 columns while using the 2-D pie chart, the chart will ignore entries beyond the first 2 columns.Select the data across the 2 columns in question.Ī larger view of the 2-D pie chart is as follows: The procedure to create a pie chart for data spread across 2 columns only is simple. In this article, we would consider the Hierarchical Sunburst chart as a type of pie chart, though the procedure for adding it is a little different. If you wish to create a pie chart in Excel, please read through this article. A pie chart is a usually 2-dimensional chart used for comparing values between 2 columns. While you are provided with a lot of options for creating charts in Excel, every chart has a different scope and different use.
0 kommentar(er)
