Some of this just involves setting up extra rows/columns. It is a regular clustered column chart, where there is an empty row between each "region", and some empty rows at the bottom and the top. Office-365 allows me to set up data labels that include both the "actual value" and add in more stuff based on another cell, but you see that my labels have the percentage on top and are not decimally aligned.
I do suspect that this was made pre-Office 365, where the region names are just text boxes and either the data labels are finagled to have the data labels coming from a column that isn't officially part of the chart.
The sample chart has your "picture" chart on slide 1 and my editable chart on slide 2. If you edit the chart, you should see the extra rows and columns, including a column where I join together (concatenate) the number and percentage.
|