Multiple Data lablels for one slice of the pie chart

Hi

In each 6 segments shown in pie chart I want to show the percentage share of all the Deptts like bellow:

Enhance BAC’s Business Governance % of IT,% of Finance, % of HR
Ensure BIA is a great place to work % of IT,% of Finance, % of HR
Improve BIA Assets and Infrastructure % of IT,% of Finance, % of HR
Improve Customer Satisfaction % of IT,% of Finance, % of HR
Improve Operations and Business Performance % of IT,% of Finance, % of HR
Improve Revenue and Manage Costs % of IT,% of Finance, % of HR

Lemme know if more explanation is required.

Best Regards
Imran Bhatti

I'm not quite sure this is what you want, but I can tweak it. I modified the workbook in a couple of ways.

I broke out the department totals into three separate columns in the source data: for example if (Department = "HR", 1, 0). I needed the individual pieces to get the total as a number that I could use in the spreadsheet.

Pivot table charts can be a pain. So I overlaid the results of the pivot table with two named ranges.
Objective =OFFSET(Sheet2!$A$4,0,0,COUNTA(Sheet2!$A:$A)-2,1)
Total =OFFSET(Objective,0,5)

I used these to construct the pie charts. These two wikis explain dynamic ranges and dynamic charting.
http://www.utteraccess.com/wiki/Offs...Dynamic_Ranges
http://www.utteraccess.com/wiki/Dynamic_Charting

I formatted the labels to show the category and the percents.

I inserted a slicer on the pivot table so you can select individual departments.

The spreadsheet will pick up on new objectives automatically. It will not pick up on new departments. These will have to be added to the source data and the pivot table manually. You will have to adjust the calculated formula in the pivot table for the Total. And finally, you will have to change the definition of the named range containing the percents since it will have moved over a column or two.

Hi dflak

Sorry for late response. I appreciate your effort

But actually I want the percentage contribution of departments towards the strategic objectives (six slices of the pie). It is well achieved with donut chart but the problem with dougnut is that it shows the separate ring for each series(departments). I tried to make the extra rings as colorless but problem is the leader lines are directing to the invisible rings which looks odd. while my goal is to show the datalabels(deptts) with a leader line pointing to the same slice.

Any way. I am still in search of a tweek or chart hack to achieve it if possible.

Best Regards
Imran Bhatti

Hello,

you need to create the text for each label with formulas in a cell. Then you can format the labels and use "Value from cells" to select the cells with the formula. For example

="Enhance BAC’s Business Governance"&CHAR(10)&TEXT(B5/E5,"0%")&" of IT, "&TEXT(C5/E5,"0%")&" of Finance, "&TEXT(D5/E5,"0%")&" of HR"

Copy down and replace the text at the beginning.

The chart will look really, really ugly with all that text crammed in, but pie charts are not the best visualisation for this, anyway.

cheers, teylyn

Hi sir teylyn

Due to the ugliness of long text. I migrated to column chart instead.Thanks for your time to review my problem.

Best Regards
Imran Bhatti

Good decision!