399539_en-US

liliconcom

Graph Builder - Pie chart: display simultaneously label by row and label by percent of total values

Hello everybody,

I would like to know if it feasible to display two kind of labels on Pie Chart? Instead of choosing between "Percent of Total Values" and "By row" (in association with a Label column) I would like to display these two information simultaneously.

 

Any idea of how we can do that?

 

Many thanks in advance!

 

 

 

GraphicsRe: Graph Builder - Pie chart: display simultaneously label by row and label by percent of total values

Hi Anne,

You may have already thought of the workaround but have you considered creating a composite of the Label and Percent of Total like shown below.

If it is something that could be useful to you, here simple table with 2 extra columns to generate the composite labels: you'll see that the formulas are quite simple.

Best,

TS

 

Re: Graph Builder - Pie chart: display simultaneously label by row and label by percent of total values

Tahnks a lot@Thierry_S for this nice workaround.

I just would like to go one step further, if possible, and be able to use the Local Data Filter. Would be possible to adapt your formula so that the percentage are recalculated based on the current selection?