Excel Graphing question

**shantibala** · 12-11-2008, 05:36 AM

Hey Guys,

I am doing some behavioral observation with cockroaches and we are observing their grooming patterns.

Basically they groom 8 appendages and my codes for them are

A, C, P, HL, FL, L, Pause,AB...

So over a 20 minute period or so i observe and note what part they groom and for how long. After that i put my data in an excel sheet and i make a bar graph. I want to use a bar graph that shows the sequence of grooming and i want all the a's nomatter the location of the cell to be one color and c's to be one color and so on.. i have attached a spreadsheet of what my data looks like..

how would i do that?

Thanks in advance!

Shant

**shantibala** · 12-11-2008, 03:55 PM

How can i write a if statement so that when i make a graph certain letters will be certain colors for all the letters on a sheet using a bar chart..

for example.

if "a" then i want it to appear red

if c i want it to appear yellow

**shantibala** · 12-11-2008, 03:56 PM

How can i write a if statement so that when i make a graph certain letters will be certain colors for all the letters on a sheet using a bar chart..

for example.

if "a" then i want it to appear red

if c i want it to appear yellow

**Andy Pope** · 12-11-2008, 06:25 PM

You will need code.
http://peltiertech.com/WordPress/200...ategory-label/

Or set up multiple series for each colour and IF formulas.
It would help to see a workbook example if the VBA solution is not suitable.

**Andy Pope** · 12-11-2008, 06:40 PM

You can use multiple series, in a stacked bar chart.
With formula to display bar if appropriate.

**shantibala** · 12-11-2008, 07:13 PM

sure here is my workbook example, see as the A's change color going down the bar graph, i just need help writing a code to restrict the A letter to be only one color and the same with the C and the same with the other letters, but all i need is just one example i will do the rest myself

**Andy Pope** · 12-11-2008, 07:16 PM

Here is a version more link a gantt chart.

I have merged all your posts on the same top. Please don't start multiple posts on the same problem.

**shantibala** · 12-11-2008, 07:21 PM

andy! thank you so much for all your help!

one last question, how can i change this to be a one colum bar chart stacked like the attached spreadsheet