Can someone please tell me if there are any limitations on the values for chxr ? I am trying to display this simple chart with financial values, some of them can be negative (for example when a company had a profit loss):
http://chart.apis.google.com/chart?chs=600x500&cht=bvg&chbh=a&chd=t:57.96,48.62,91.02|61,48.56,95.51|-3.04,0.06,-4.49& chds=-4.49,95.51&chxt=x,y&chxl=0:|12/31/2007|06/30/2008| 12/31/2008&chxr=1,-465000000,9891000000&chco=5d99ff,c6d9fd,4d89f9 The y-axis labels are not displayed correctly!! They are generated automatically by using the chxr parameter: chxr=1,-465000000,9891000000 When I change the ratio between min and max like this: chxr=1,-465000000,989100000 (I removed a zero from the max value) then the axis labels are displayed from -400000000 to 900000000. (But they are what I want, because this is not the correct range of my values) But when I use chxr=1,-465000000,9891000000 (which is the correct range that I want to display), then they are instead displayed from 0 to 9500000000. Does it have to do with the fact that the ratio 465000000 / 989100000 = 0.470124355 which is less than 1? (While the ratio 465000000 / 98910000 = 4.70124355 which is greater than 1) Probably it has to do with the ratio, because when I drop one zero from both min and max values (which makes them chxr=1,-46500000,989100000), they are again displayed starting from 0 ! Also if you look carefully, there seems to be another bug: Although I specified min=-465000000, the minimum value displayed is -400000000 ! Why ?? Shouldn't it be something like -450000000? Or -500000000? How can it be OVER the minimum value that I specified?! This just means that the minimum value is truncated. And the same applies for the maximum value, which is displayed as 9000000000 (9 billion), which is BELOW the maximum value that I specified (9891000000 = more than 9 billion). This again means that the maximum value is truncated. And the same applies in the case with the ratio greater than 1: the maximum value displayed is 9.5 billion, which is below my actual maximum value, which is 9.89 billion. I guess this is really a bug that should be fixed, guys... P.S. I mention also that my initial min and max values were -465,013,141 and 9,890,539,526, but I "rounded" them to only use 4 non- zero digits, because I assumed that somehow the same limitation from "Text encoding with data scaling" applied here, although for chxr it was not specified as such: (quote from the specification for "Text encoding with data scaling":) Valid values range from (+/-)9.999e(+/-)100, and only four non-zero digits are supported (that is, 123400, 1234, 12.34, and 0.1234 are valid, but 12345, 123.45 and 123400.5 are not). (end quote) And one last thing, since we got to this: Is there any way to specify number formating (with thousands separator) for the y-axis labels? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Chart API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-chart-api?hl=en -~----------~----~----~----~------~----~------~--~---
