Office hacks: radar chart combined with pie charts to complete the data comparison

A head office wants to compare the product sales of its subsidiaries and each parameter of each product. If you use pie charts and radar charts and set them into a combined chart, the comparison effect will be clear at a glance (Figure 1). Next, let’s see how to make such a chart.

1820A-LHDB-1

First, add a column to the original data to calculate the proportion of each subsidiary in the total sales, and use the result as the data source for the pie chart. Select the sales data of each subsidiary and each product (i.e., A1:E6), select the “Insert” tab, click “Waterfall → Radar Chart with Data Marker”, select the inserted chart, click “Chart Tools → Design “in the desired style, the design of a good style for the chart (Figure 2).

1820A-LHDB-2

Next, select the pie chart data source (i.e. A2:A6, G2:G6), copy the data, select the chart and paste it; right-click the chart, select “Change Chart Type”, select “Combination” in the pop-up window, and set the chart type for each product to Set the chart type of each product as “Radar chart with data markers”, and set the chart type of series 5 as “Pie chart” (Figure 3).

1820A-LHDB-3

Next, right-click on the pie chart in the chart, select “Set Data Series Format”, and in the “Series Options” tab, adjust the starting angle of the first sector so that the company represented by each pie chart corresponds to the data of the corresponding company in the radar chart; adjust the pie chart separation percentage (Figure 4).

1820A-LHDB-4

Select the pie chart, set its fill colorless to “Solid Fill”, and delete the label representing the company in the radar chart. Select the pie chart, click “Chart Tools→Add Chart Element→Data Label→Data Label” to add numeric labels to the pie chart. Right-click on the network line of the radar chart and select “Set Grid Line Format”, then you can set it as needed in the right window.

Finally, delete the “Series 5” in the legend and change the chart title. Of course, the chart can be further beautified as needed. In this way, the pie chart and the radar chart are combined, and the comparison between the data is obvious.

Tip: Of course, you can also change the pie chart to a doughnut chart as needed, which also requires adjusting the starting angle of the first sector and adjusting the size of the inner diameter of the doughnut chart to further beautify the combined chart.

Leave a Comment