I need to draw a chart with 4 criteria, what's the best tool ?

35 views
Skip to first unread message

Cécile Almonté

unread,
Apr 16, 2016, 5:07:54 AM4/16/16
to Google Visualization API
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 !


Daniel LaLiberte

unread,
Apr 18, 2016, 10:14:37 AM4/18/16
to Google Visualization API
Hi Cécile

I didn't study your description in detail, but it would help to have a picture of what you are talking about.  Could you sketch how these 4 superimposed bar charts might look?

--
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 google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
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.



--

Cécile Almonté

unread,
Apr 20, 2016, 4:06:30 PM4/20/16
to Google Visualization API
Hi Daniel,

thank you for taking the time to answer me, I'm sorry I was offline ! I still need to do this visualization, though.

Here's a drawing of what I think it should look like.

There are four bar charts, one for each person taking part in the conversation.

each bar represents a sentence uttered. it is as long as there are letters in the sentence. Its color depends on its content, each sentence has been tagged according to an analysis grid, each tag has a color. A sentence can be tagged several times so the bar can have 2 or 3 colors. Those tags do not have a "weight" so the different colors should be equally high if there are several in one bar. 

Since it's the sentences that are numbered in column A there can only be one at a time, I need to have a blank space in three charts when there is a bar in the fourth one, so that I can superimpose them.

Thank you for your time and your insights !

sincerely,

Cécile



On Monday, April 18, 2016 at 4:14:37 PM UTC+2, Daniel LaLiberte wrote:
Hi Cécile

I didn't study your description in detail, but it would help to have a picture of what you are talking about.  Could you sketch how these 4 superimposed bar charts might look?
On Sat, Apr 16, 2016 at 5:07 AM, Cécile Almonté <calm...@amakuru.net> wrote:
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 google-visualization-api+unsub...@googlegroups.com.



--
IMG_2791.JPG

Daniel LaLiberte

unread,
Apr 20, 2016, 4:33:31 PM4/20/16
to Google Visualization API
OK, I am still not following the details of the data you are charting, but no matter.  I can tell you how you might generate this series of charts.


Each row of your data will correspond to one column stack.
Each item in a column stack comes from a series in a column of the DataTable that you provide as input.  

By default, the color of every value in the same series will be the same.  That means the first item in every column stack will be colored the same, and the second item in every column stack will be colored the same, but a different color than for the first item.  But you can override the color of every single item by adding a 'style' role column after each series.  See https://developers.google.com/chart/interactive/docs/roles

Hope that helps.




On Wed, Apr 20, 2016 at 4:06 PM, Cécile Almonté <calm...@amakuru.net> wrote:
Hi Daniel,

thank you for taking the time to answer me, I'm sorry I was offline ! I still need to do this visualization, though.

Here's a drawing of what I think it should look like.

There are four bar charts, one for each person taking part in the conversation.

each bar represents a sentence uttered. it is as long as there are letters in the sentence. Its color depends on its content, each sentence has been tagged according to an analysis grid, each tag has a color. A sentence can be tagged several times so the bar can have 2 or 3 colors. Those tags do not have a "weight" so the different colors should be equally high if there are several in one bar. 

Since it's the sentences that are numbered in column A there can only be one at a time, I need to have a blank space in three charts when there is a bar in the fourth one, so that I can superimpose them.

Thank you for your time and your insights !

sincerely,

Cécile



On Monday, April 18, 2016 at 4:14:37 PM UTC+2, Daniel LaLiberte wrote:
Hi Cécile

I didn't study your description in detail, but it would help to have a picture of what you are talking about.  Could you sketch how these 4 superimposed bar charts might look?
On Sat, Apr 16, 2016 at 5:07 AM, Cécile Almonté <calm...@amakuru.net> wrote:
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 google-visualizati...@googlegroups.com.



--

--
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 google-visualizati...@googlegroups.com.

To post to this group, send email to google-visua...@googlegroups.com.
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/10156f29-21dd-4406-95ea-18876e991575%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



--
Reply all
Reply to author
Forward
0 new messages