chart with gene per patient

[BROEA]

Can I make a chart with a color per gene per patient as in my document?

Thx,

An

[MrShorty]

I'm optimistic that it is possible.

I would suggest you start with this tutorial about "conditional formatting" in charts: http://peltiertech.com/conditional-f...-excel-charts/ Note that most of the work is arranging the data in the spreadsheet. Once the data are arranged in the spreadsheet, then creating the chart is easy. A pivot table might be the easiest way to rearrange the data.