Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
Can you please tell me about
1 how to disaply values on data points on pie chart .
2 How to get previous month.
Thanks,
Hi
On the expressions tab there is an option under Display Options which allows you to show these.

As for getting the previous month, it depends what you mean. Are you looking to have the pie chart show lasts months data, or to just derive last month for a formula? Can you expand the problem please?
Regards
Steve
Hello Shivali,
To display the values on data point.
Please go to Properties > Expression Tab > Values on Data Point (At the bottom)
I did not understood point 2, hope point 1 is answered.
Thanks
Advait
It is the same way as in bar chart, in expression tab, check 'Values on Data Points'. If you are thinking of getting values within the pie slices, that is not possible in pie chart.
Previous month: =Month(Month(Date)-1)
Hi
1
for add datapoints in expression tab-select values on datapoint
if u want values on legend then goto presentation tab-select show numbers in legend check box
2
for previous month
use addmonths function