Thank you for the quick answer, Dan, You were totally right about the formatting option. I have both baseline and minValue options set as 0,00001 and format option as '#,##0.00%'. So 0.00% and 0.01% values are just result of rounding.
Also you were right about minorGridlines option. Graphic with gridlines.count = -1 option looks almost the same as graphic with options gridlines.count = 5 and minorGridlines.count = 1. Anyway it would be perfect if I could use gridlines.count = -1 option and not see minor gridlines at the same time. I tried use gridlines.count = -1 and minorGridlines.count = 0 options together but it had no effect. As I understand in my case he subdivisions of .5 and 5 are not minor gridlines, but rather gridlines. Your answer was really helpful. Now I can move forward in my investigation. Best regards, Dmytro Zhydchenko. вторник, 23 июля 2013 г., 15:58:57 UTC+3 пользователь Daniel LaLiberte написал: > > Hi Dmytro, > > First, on a log scale, the log of 0 is negative infinity, so the 0 > gridline would be infinitely far away. I suspect that what you are seeing > at 0.00% is really 0.001%, and your formatting is hiding the last digit. > Also, the first 0.01% is really 0.005 rounded up to 0.01. So if you want > to use log scale with a BarChart, you have this inherent conflict because > the bar is typically based at 0. It might make sense for you to specify > a baseline that is non-zero but still very small, such as 0.001%. Another > option is to use the 'mirror log' mode, which works with both positive and > negative numbers, and is linear around zero. > > Anyway, your question is really about the subdivisions of .5 and 5, and > the answer is that these occur sometimes with the auto gridline mode when > the gridline count is -1, which is the default. They are correctly > positioned, and you would see the same if you specify an explicit gridline > count of 5 with a minor gridline count of 1. Hope that helps. > > dan > > > On Tue, Jul 23, 2013 at 7:56 AM, Dmytro Zhydchenko > <[email protected]<javascript:> > > wrote: > >> Hi all, >> >> I have an issue with gridlines representation on the BarChart graphic. >> The screenshot is attached. >> >> The thing is I want to see "0, 0.1, 1, 10" values, but also I can see the >> following unnecessary values: "0.1, 0.5, 5". I wonder what option is >> responsible for this behavior. I'd like to turn it off. >> >> I use logScale option. Also both baseline and minValue options are used. >> Anyway I don't use gridlines option explicitly. As I understand "-1" value >> is used by default in my case. >> >> I can use exact number for gridlines i.e. hAxis.gridlines.count = 5, but >> unfortunately I'm not sure this one is a suitable solution for me. >> >> TIA >> >> -- >> 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]<javascript:> >> . >> To post to this group, send email to >> [email protected]<javascript:> >> . >> Visit this group at >> http://groups.google.com/group/google-visualization-api. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > > > -- > Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> > - 978-394-1058 > [email protected] <javascript:> 562D 5CC, Cambridge MA > [email protected] <javascript:> 9 Juniper Ridge Road, Acton 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 http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
