Hi Hitesh, The timeofday formatting doesn't currently know how to display values for hours outside the normal range of a day since we use the standard Google closure date/time formatting utilities that uses a subset of the ICU formatting rules documented here: http://userguide.icu-project.org/formatparse/datetime . Probably the correct solution would be to add a formatting option to indicate you want unbounded hours. The same would apply to each of the other date/time units: seconds, milliseconds, minutes, days and months.
In the meantime, you can include a day number in the format to at least make the values be distinct and correct. On Sat, Mar 5, 2016 at 2:32 AM, Hitesh Jain <[email protected]> wrote: > Hi > > I want to plot data on line chart where each rows corresponds to 1 month > and columns contain duration. > > Following sheet contain sample data and plotted chart. > > https://docs.google.com/spreadsheets/d/1Dyf0wZ5m4SszDkXuey-0251wZXeXPYMnHFXOgZBjB8o/edit#gid=0 > > I want to plot duration on Y axis such that it starts at 0:00 but in the > chart it starts at 16:00 (I think it is doing so because duration more than > 24:00 rolls up back to next day). I know this can be solved by making > duration a decimal value (like 01:30 can be change to 1.5) but I want data > to remain in format hh:mm for better readability. Moreover MS excel plots > this correctly (I've attached an image in the document itself) > > > Thanks > > > -- > 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/625cf1b3-44b6-47b2-9a9d-ca61a6f9cef6%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/625cf1b3-44b6-47b2-9a9d-ca61a6f9cef6%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> [email protected] <[email protected]> 5CC, Cambridge 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 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/CAOtcSJMA5TFCnF-rQipaaS-PceS%3D-B3h5WFoT%2Brj4_QSxGUapA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
