I've developed a number of pie and bar charts where I also need to track volumes and percentages for each area shown in the chart. I've entered calcs in a number of different ways yet all I get are error messages.
For example, I have a pie chart that shows each of the 12 functional areas from within my table, one for each slice of the pie. The chart also shows the appropriate percentage for each functional area. What I need in addition to that are two things:
1. I'd like each slice to not only show the functional name, but also the appropriate percentage and volume for each slice.
2. I'd also like to able to show the total volume at the bottom of my pie chart.
What am I doing wrong?
For example, I have a pie chart that shows each of the 12 functional areas from within my table, one for each slice of the pie. The chart also shows the appropriate percentage for each functional area. What I need in addition to that are two things:
1. I'd like each slice to not only show the functional name, but also the appropriate percentage and volume for each slice.
2. I'd also like to able to show the total volume at the bottom of my pie chart.
What am I doing wrong?