Hello,

I need to draw a bar chart, that will actually divide itself into 4 bar 
charts that can be superimposed. I want to make a visualization of a 
conversation between 4 people.

Each chart would be the visualization of the data relevant to Choice 1, 2, 
3 or 4 in Column B of my table : that's the name of people talking.

The abscisssa axis would be Column A of my table, it's just an id that goes 
from 1 to 400, that's the number of total utterances in the conversation.

The height of the bars would be Column C, that's the number of signs in the 
utterance. I would need to have a blank in the chart every time the line 
corresponding to the id is an utterance from someone else than the person 
the chart is about. (so that I can superimpose them, in the end)

Finally, the bars would have to be colored depending on Columns D, E and F 
which each have several possible choices. So, I guess coding D1, light 
blue, D2 darker blue, D3 dark blue and E1, E2, E3 shades of red and Fs 
shades of green. For example.

Obiviously, I'm totally new to all this. My table is on a Google sheet, I 
probably will have to do some "cleaning" of the data, but the whole 
conversation has been tagged, I *only* need to find the right tool to link 
each column/cell to the right place…

Thank you ever so much to whoever might be able to help me !


-- 
You received this message because you are subscribed to the Google Groups 
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/ba57c849-7eed-45ec-b230-7f146d8cf2a2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to