We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Inserting Charts Based on Content (Text) [closed]

asked 2012-08-15 01:59:01 +0200

Tech.CG gravatar image

updated 2020-07-21 19:27:02 +0200

Alex Kemp gravatar image

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!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-23 02:08:06.592715

1 Answer

Sort by » oldest newest most voted

answered 2013-02-22 10:47:01 +0200

mahfiaz gravatar image

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.

edit flag offensive delete link more

Question Tools


Asked: 2012-08-15 01:59:01 +0200

Seen: 404 times

Last updated: Feb 22 '13