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:
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
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.