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.
You should just use a ColumnChart with stacking. https://developers.google.com/chart/interactive/docs/gallery/columnchart#stacked-column-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é <[email protected]> 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 >> <https://plus.sandbox.google.com/u/0/107983990964002553785?prsrc=4> >> >> 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é <[email protected]> >> 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 [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 >>> <https://groups.google.com/d/msgid/google-visualization-api/ba57c849-7eed-45ec-b230-7f146d8cf2a2%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> >> [email protected] 5CC, Cambridge MA >> > -- > 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/10156f29-21dd-4406-95ea-18876e991575%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/10156f29-21dd-4406-95ea-18876e991575%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> [email protected] <[email protected]> 5CC, Cambridge MA -- 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/CAOtcSJMhO-VU2_Wi%2Bo0c-L9F2iC%2BncXk0mG3kC4NYWwViFYk_g%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
