How can I create a stacked area graph of time/duration values?
I have a set of times for each date which correspond to each leg of a journey. https://docs.google.com/spreadsheet/ccc?key=0AlOsQm5RC6U5dFBVazA2eGItcFZ6YjVGR3hTNU0wT2c&usp=sharing
If these columns are formatted as a number, I can create a stacked graph which displays fine, but as soon as the columns are formatted as times (the exact same value) or "hours" then it won't let me create a stacked graph and the graph created when it was numeric draws all points at 0.
The required data format for the Area chart doesn't match the current data.
The first column should contain the category label. Data values should appear as numeric columns. Each numeric column may be followed by one or two text columns. The text in the first column will be displayed as annotations above the data points. The text in the second column will be displayed in a hover-card when hovering over the point.
The Y axis does correctly format the values as times, and up to this morning, it rendered time/hours formatted values correctly.