First time here? Check out the FAQ!
asked 2012-08-15 01:59:01 +0200Tech.CG
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!
answered 2013-02-22 10:47:01 +0200mahfiaz
I have no idea why would you use pie charts for that. Just because you can?
For pie charts you should create two column table, let the number be same for everything (e.g 1): Motorfist 1 Walls 1 Hoody 1
Now first column would be label and the second one is just a number by which the slice size is calculated.
As for getting information from other files, just type = and click on a cell in the other file followed by an enter. Simple.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-08-15 01:59:01 +0200
Seen: 58 times
Last updated: Feb 22