Hi there,
In my job we order inventory via Calc sheets. We are trying to insert a pie graph of what we order. Some of the cells will have words such as Motorfist, Hoody, and Walls. We would like a pie graph that has hoodies be a certain color, for instance yellow. Walls another color and Motorfist another color.
The issue that I have ran into is that the charts do not work correctly, I think it is because the cells have words and not numbers. Any suggestions?
Also, is it possible to have the pie graph bring in inventory items from another workbook? We want to know the amount of certain coats that we order throughout the year. For example, we order the inventory every two weeks or so. When we write a new order we use a template to create a new sheet. If we could make a graph sheet that got information from all of the other sheets available, it would make the boss really happy!