I'm trying to track quantities that have been completed. I have two columns, E is quantity and F is completion. When I make a pie chart and the quantity is completed, it shows on the chart as 50% qty and 50% comp. I want it to show 0% qty and 100% comp.
Mac OS X (10.7.2)
DS,
To solve your problem, you will need to plot two columns that are complementary, such as "Incomplete" and "Complete".
Jerry
Hey Jerry,
What the difference with what I have and what you suggest?
Will try though
Jerry,
How do you hid columns from being printed?
Hello Jerry,
It still comes out the same. I must be doing something wrong.
Also, How do you hid columns from being printed?
DS,
I'm sorry, but I don't know what you mean by Quantity and Completion, so I can't but my suggestion in relative terms.
Let's say that you have a requirement to produce 100 pieces. That might be in a column called Quantity Reqiured.
Let's also say that you have a column called Number of pieces Completed. Those may indeed be your Quantity and Completion columns, but I'm not sure. You would also need a column titled something like Uncompleted Production Reuirement, which would be Quantity Required minus Number of Pieces Completed. Then you would make a pie chart that took it's data from the columns Number of Pieces Completed and Uncompleted Production Requirement. Since the total production requirement never changes, it has no place in the pie chart.
Jerry
Thanks Jerry!
How can you hid columns or rows from being printed?
Thanks for the feedback, ds.
Columns may be hidden one at a time by hovering over the column label and clicking the control button that appears, selecting Hide.
You may also select a number of columns and then hover over any one of them and make the same choice, or use the Table menu.
Jerry
Pie Chart %
