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. For more options, visit https://groups.google.com/d/optout.
