Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pie Chart: Can one view % and count simultaneously?

I would like my Pie Chart to simultaneously show me the count of values, and what % that count makes of the overall Pie Chart. At the moment, all I can get is one or the other.

Thanks

Daniel

2 Replies
Not applicable
Author

Hello, you can go to the presentation tab and add a new "text in chart" expression to either display % or count. This will create an extra label, apart of what is shown in the chart already.

Regards

Not applicable
Author

Hi Daniel,

try DUAL function, like this:

Dual(

Num(Sum(sales)/Sum(Total sale),'0.00%') & chr(13) & Num(Sum(sales),'#,##0'),

Sum(sales)

)

with flag "values on data points"

Alex