Ask Your Question

yeehi's profile - activity

2014-11-19 05:22:27 +0200 received badge  Famous Question (source)
2014-10-06 10:49:32 +0200 received badge  Notable Question (source)
2014-10-05 13:43:15 +0200 received badge  Popular Question (source)
2014-10-05 03:54:34 +0200 received badge  Editor (source)
2014-10-05 03:53:53 +0200 asked a question How to automatically assign different colours to categories in a bar chart

I would like to represent a sequence of categories in bar chart form. I would like the different categories to each have its own colour bar.

The x axis would consist of the sequence, for example:

ACTGAGCTCCAGA

A=Red C=Green T=Blue G=Yellow

How can all of the As be made to appear Red, without having to individually set ever instance of A?

The Y axis is a percentage value, 0-100%.

y values: 385976294480983
x values: ACTGAGCTCCAGA

A C T G A G C T C C A G A
3 8 5 9 7 6 2 9 4 4 8 0 9 8 3

Note:

In the "Data Range" section of the chart wizard, selecting "Data series in columns" results in different coloured columns for every column. In the required instance, 4 colours, no more nore less, are needed, one colour for each of the four values, ACTG.