Creating a Pie Chart
Creating a Pie Chart
I am trying to create pie chart for employee vacation tracking.
In the "add employee" form there is a field for total accrued vacation.
In the "add leave" form is used to track leave requests.
I want the pie chart to show total accrued vacation with the total approved vacation as the smaller inside of the pie chart.
I have tried using the pivot table function.
using the add aggregate formula function, I made a formula to total all leave requests.
but it wont create a pie chart out of the two data points.
any help would be great.
thanks.