Pure genius !! Thanks a lot
On Thursday, February 20, 2014 10:57:31 PM UTC+7, asgallant wrote:
>
> You cannot stack two elements from the same data series at the same point.
> You would have to create separate data series to hold the negative values
> (and probably use the series option to make colors match and hide the
> negative series from the legend). Something like this:
>
> {"cols":[
> {"id":"","label":"","pattern":"","type":"date","p":{}},
> {"id":"","label":"Initiator","pattern":"","type":"number"},
> {"id":"","label":"Enforcer","pattern":"","type":"number","p":{}},
> {"id":"","label":"CR / Ethics /
> Governance","pattern":"","type":"number","p":{}},
> {"id":"","label":"Promoting Int. Labor
> Standards","pattern":"","type":"number","p":{}},
> {"id":"","label":"Improving factory
> conditions","pattern":"","type":"number"},
> {"id":"","label":"Initiator","pattern":"","type":"number"},
> {"id":"","label":"Enforcer","pattern":"","type":"number","p":{}},
> {"id":"","label":"CR / Ethics /
> Governance","pattern":"","type":"number","p":{}},
> {"id":"","label":"Promoting Int. Labor
> Standards","pattern":"","type":"number","p":{}},
> {"id":"","label":"Improving factory
> conditions","pattern":"","type":"number"}],
>
> "rows":[{"c":[{"v":"Date(2014, 1,
> 1)","f":"2014"},{"v":1,"f":null},{"v":0,"f":null},{"v":2,"f":null},{"v":1,"f":null},{"v":1,"f":null},{"v":-2,"f":null},{"v":-3,"f":null},{"v":-1,"f":null},{"v":0,"f":null},{"v":0,"f":null}]}]
> ,"p":null}
>
> See example: http://jsfiddle.net/asgallant/RHhjL/
>
> On Wednesday, February 19, 2014 10:12:16 PM UTC-5, Jerome B wrote:
>>
>> Hi All,
>>
>> I'd like to draw a stacked column chart which would show both positive
>> and negative values of the same data over a period of time using a
>> ControlWrapper.
>>
>> Using the following data table, I almost get there but negative values
>> are not under the positive but next to them (see attached image):
>>
>> {"cols":[
>> {"id":"","label":"","pattern":"","type":"date","p":{}},
>> {"id":"","label":"Initiator","pattern":"","type":"number"},
>> {"id":"","label":"Enforcer","pattern":"","type":"number","p":{}},
>> {"id":"","label":"CR / Ethics /
>> Governance","pattern":"","type":"number","p":{}},
>> {"id":"","label":"Promoting Int. Labor
>> Standards","pattern":"","type":"number","p":{}},
>> {"id":"","label":"Improving factory
>> conditions","pattern":"","type":"number"}],
>>
>> "rows":[
>> {"c":[{"v":"Date(2014, 1,
>> 1)","f":"2014"},{"v":1,"f":null},{"v":0,"f":null},{"v":2,"f":null},{"v":1,"f":null},{"v":1,"f":null}]},
>> {"c":[{"v":"Date(2014, 1,
>> 1)","f":null},{"v":-2,"f":null},{"v":-3,"f":null},{"v":-1,"f":null},{"v":0,"f":null},{"v":0,"f":null}]}]
>> ,"p":null}
>>
>>
>> <https://lh4.googleusercontent.com/-vEZnwUFgBk0/UwVyZnEoKpI/AAAAAAAAAPI/-khHtpOue4w/s1600/charts_negative.jpg>
>>
>>
>> Any idea how to achieve this ?
>> Thanks for your help
>>
>>
>>
--
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 http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.
