Line not showing where values are zero

51 views
Skip to first unread message

neilpaterson

unread,
Dec 16, 2011, 10:44:11 AM12/16/11
to Google Chart API
Hi

I'm having an issue whereby one of the lines on my chart has missing
sections where the value is zero. Please see the black line on the
chart below:

http://chart.apis.google.com/chart?cht=lc&chs=900x300&chxt=x,x,y,y,r,r&chds=5,3500&chm=d,FE8200,0,-1,10|s,2E353D,1,-1,7&chxl=0:|Dec%202010|Jan%202011|Feb%202011|Mar%202011|Apr%202011|May%202011|Jun%202011|Jul%202011|Aug%202011|Sep%202011|Oct%202011|Nov%202011|1:|Month|2:|0|500|1,000|1,500|2,000|2,500|3:|One%20Thing|4:|0|500|1,000|1,500|2,000|2,500|3,000|3,500|5:|Another%20Thing&chxp=1,50|3,50|5,50&chxr=2,0,2500,500|4,0,3500,500&chco=FE8200,2E353D&chdl=One+Thing|Another+Thing&chdlp=b|l&chd=t:-1,151,423,377,64,389,393,471,392,210,976,2024|1,323.67,2123.15,722.62,3254.2,46.95,555.6,967.93,1483.23,1,510.24,2903.26

Dec 2010 and Sep 2011 are both known to be 0.00, and I'd like the line
chart to show this.

Can anyone help??

Thanks

Neil

duniyadnd

unread,
Dec 18, 2011, 6:30:07 PM12/18/11
to google-c...@googlegroups.com
it seems to do this when the it is less than 5px, it doesn't show. Sorry, I didn't try to figure out why it wasn't working - but if run it like this, should provide the result you're looking for.

Message has been deleted
Message has been deleted

neilpaterson

unread,
Dec 20, 2011, 5:37:46 AM12/20/11
to Google Chart API
Thanks duniyadnd but I've just realised the forum seems to have messed
up the URL. Please reform the following back into one line to get the
correct URL:

http://chart.apis.google.com/chart?cht=lc
&chs=900x300
&chxt=x,x,y,y,r,r
&chds=5,3500
&chm=d,FE8200,0,-1,10|s,2E353D,1,-1,7


&chxl=0:|Dec%202010|Jan%202011|Feb%202011|Mar%202011|Apr%202011|May
%202011|Jun%202011|Jul%202011|Aug%202011|Sep%202011|Oct%202011|Nov
%202011|1:|Month|2:|0|500|1,000|1,500|2,000|2,500|3:|One%20Thing|4:|0|
500|1,000|1,500|2,000|2,500|3,000|3,500|5:|Another%20Thing
&chxp=1,50|3,50|5,50
&chxr=2,0,2500,500|4,0,3500,500
&chco=FE8200,2E353D

&chdl=One%20Thing|Another%20Thing
&chdlp=b|l
&chd=t:-1,151,423,377,64,389,393,471,392,210,976,2024|
0.00,322.67,2122.15,721.62,3253.20,45.95,554.60,966.93,1482.23,0.00,509.24,2902.26

Can anyone help?

Thanks

Neil

On Dec 18, 11:30 pm, duniyadnd <umangb...@gmail.com> wrote:
> it seems to do this when the it is less than 5px, it doesn't show. Sorry, I
> didn't try to figure out why it wasn't working - but if run it like this,
> should provide the result you're looking for.
>

> http://chart.apis.google.com/chart?cht=lc&chs=900x300&chxt=x,x,y,y,r,...s,2E353D,1,-1,7&chxl=0:|Dec%202010|Jan%202011|Feb%202011|Mar%202011|Apr%202011|May%202011|Jun%202011|Jul%202011|Aug%202011|Sep%202011|Oct%202011|Nov%202011|1:|Month|2:|0|500|1,000|1,500|2,000|2,500|3:|One%20Thing|4:|0|500|1,000|1,500|2,000|2,500|3,000|3,500|5:|Another%20Thing&chxp=1,50|3,50|5,50&chxr=2,0,2500,500|4,0,3500,500&chco=FE8200,2E353D&chdl=One+Thing|Another+Thing&chdlp=b|l&chd=t:-1,151,423,377,64,389,393,471,392,210,976,2024|1,323.67,2123.15,722.62,3254.2,46.95,555.6,967.93,1483.23,5,510.24,2903.26

neilpaterson

unread,
Dec 20, 2011, 6:10:23 AM12/20/11
to Google Chart API
Not to worry, I found the issue - chds (custom scaling param) was
wrong.

Neil

On Dec 20, 10:37 am, neilpaterson <npater...@clickthrough-

> >http://chart.apis.google.com/chart?cht=lc&chs=900x300&chxt=x,x,y,y,r,...Dec%202010|Jan%202011|Feb%202011|Mar%202011|Apr%202011|May%202011|Jun%202011|Jul%202011|Aug%202011|Sep%202011|Oct%202011|Nov%202011|1:|Month|2:|0|500|1,000|1,500|2,000|2,500|3:|One%20Thing|4:|0|500|1,000|1,500|2,000|2,500|3,000|3,500|5:|Another%20Thing&chxp=1,50|3,50|5,50&chxr=2,0,2500,500|4,0,3500,500&chco=FE8200,2E353D&chdl=One+Thing|Another+Thing&chdlp=b|l&chd=t:-1,151,423,377,64,389,393,471,392,210,976,2024|1,323.67,2123.15,722.62,3254.2,46.95,555.6,967.93,1483.23,5,510.24,2903.26

Reply all
Reply to author
Forward
0 new messages