I am currently investigating Google Charts as an alternative to creating charts in Adobe Flash Builder. I am trying to find out if it is possible to create a chart that has the following characteristics.
Series 1: Column Series 2; Column Series 3: Line Series 1 and 2 are stacked, but rather that being placed one on top of the other they are superimposed over each other. This is necessary because the data should show the value of Series 1 and the value of Series 2 on rollover, but visually it shows Series 1 with Series 2 behind it so that the positive difference between them shows as if it were stacked on Series 1. A negative difference does not show because Series 1 covers Series 2. Series 3 is a line that covers Series 1 and Series 2 and shows a target value. Values for all Series are percentages. So a sample column might have the values Series 1 70%, Series 2 85%, Series 3 80%. This would show a column of 70% a stacked 15% and a line part way through the stacked 15%. Is this possible using Google Charts? I have played around for a while and haven't found a way to do this. I can created a Combo Chart with a single column and a line, or a Stacked Chart with no line and wrongly displayed data on rollover because to get it to display correctly Series 2 has to be the delta value between the Series 1 data and the Series 2 data. Any suggestions on how to achieve the results I need would be gratefully received. Attached is a sample of what I am trying to recreate, Thanks, Colin -- 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/e96da669-4aad-40fd-b5db-1e3cfc764e36%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
