How to make a chart from a non numeric valued table...?

[edenzler]

Hi, can't seem to figure out how to do this... I have the following table...

1. Product Status Inventory Running Shipment
2. catfood Red Yellow Green Red
3. dogfood Green Red Yellow Green
4. fishfood Red Green Yellow Red

Essentially trying to get to a green yellow red colored chart, just the colors in the chart, of equal value, so they can be stacked - not the text.

Thanks in advance..

Cheers.

[gfuente]

Hello

You could use eval to assign colors to numbers, and then create the chart, then assing values from the chart to specific colors...

Regards

[edenzler]

Thanks, I think I get it, can you give me the search language?