Home > google spreadsheets > Stacked area graph of time/duration values

Stacked area graph of time/duration values

February 7Hits:0
Advertisement

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.

Answers

The new behavior is likely due to an internal change since the last update introducing the new Google Sheets. My suggestion would be to add an intermediary sheet to connect to the commute chart. The new sheet would contain linked values from the Times sheet. You could then perform arithmetic and formatting operations on it while keeping the Times sheet untouched. At the end, you could also hide the supporting sheet.

An example: https://docs.google.com/spreadsheet/ccc?key=0AvNKw_kDnGPQdHVncl9BNkY0cGIteHpjNVZla0RVMVE&usp=sharing#gid=4

The downside is that the time representation you used to achieve on the chart may no longer be possible. In fact, once formatted the duration values become single points in time instead of differences between times.

Related Articles

  • Stacked area graph of time/duration valuesFebruary 7

    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 thes

  • pgf stacked bar graph with line plotSeptember 3

    I want to draw a stacked bar graph plot with one parameter as a line plot. Here is my code below - \begin{tikzpicture} \pgfplotstableread{Figures/measurements.dat} \datatable \definecolor{RYB1}{RGB}{51, 102, 153} \definecolor{RYB2}{RGB}{102, 51, 0} \

  • Need help in drawing the following Stacked Bar Graph

    Need help in drawing the following Stacked Bar GraphApril 12

    I want your help in drawing the following figure. I think it is called as stacked bar graph. --------------Solutions------------- This type of graph is easy to produce with the pgfplots package. See below for an example. For more details on ybar stac

  • Set labels to column title in a stacked bar graph

    Set labels to column title in a stacked bar graphFebruary 25

    I was trying to build a stacked bar graph which displays the labels of the columns title not in a legend, but directly near the bar itself. So far, I came up with the following: \documentclass[12pt]{amsart} \usepackage{pgfplots,pgfplotstable} \pgfplo

  • Line graph superimposed on "Grouped Stacked" bar graph with pgfplots?

    Line graph superimposed on "Grouped Stacked" bar graph with pgfplots?March 20

    I need to superimpose a line graph over a stacked grouped bar graph (similar to answer to the question: Two level labels in bar plot). I have to superimpose a line graph for each group (it breaks at boundary of group). For example: First line graph c

  • How to show the values on the bars of a stacked bar graph in 3D?

    How to show the values on the bars of a stacked bar graph in 3D?October 8

    I have created a Stacked Bar Graph (in 3D) using the Forena reports module, which looks like so: I was able to successfully create this graph. But I am having problems in showing the corresponding values on the bars. The values I want to show on the

  • Stacked Line graph line colors do not match legend

    Stacked Line graph line colors do not match legendNovember 18

    I made an interactive chart that shows different data, depending on which ActiveX checkboxes are checked. I created a few tables that would show different data by using a few nested IF statements like: =IF('Sheet1!$O$25;SUM(AV$2:AV8)/B8;IF('Sheet1'!$

  • Stacking Munin graph pluginsJanuary 25

    Is there a simple way to stack existing plugin graphs and hide the originals? For example, I'd like to stack ping_ with say, ping_google.com and ping_amazon.com together. Do I need to write a new plugin, or can I do it in the config file? And what do

  • Stacked Line Graph with fragmented data

    Stacked Line Graph with fragmented dataApril 30

    Let's start with what I already found on the internet: data = {{10, 4, 3, 0, 8, 8, 10, 8, 9, 10}, {2, 1, 2, 15, 5, 8, 7, 10, 9, 15}, {1, 4, 8, 1, 2, 8, 12, 10, 9, 15}}; ListLinePlot[Accumulate[data], Filling -> {1 -> {Axis, LightRed}, 2 -> {{1},

  • PGF stacked bar graph not drawn correctly

    PGF stacked bar graph not drawn correctlyMay 20

    I am having problem with the following code which is supposed to produce a simple stacked graph. \documentclass[tikz,border=2pt]{standalone} \usepackage{pgfplots} \usepackage{tikz} \begin{document} \begin{tikzpicture} \begin{axis}[ybar stacked] \addp

  • Perfmon in Windows 2008 R2 with multiple graphs with seperate durationsSeptember 24

    In Windows 2003 we could open perfmon and then add multiple snapins to have a console that displays perfmon say for example in 3 hours, 12 hours and 24 hours in the same .MSC. It was then easy to navigate the history and compare over time values with

  • Help with a stacked cluster graph

    Help with a stacked cluster graphDecember 8

    I want to compare the weight and volume of two power options. One consist of FC, battery and motor and the other consists of 4-stroke engines i edit the following code but it doesn't give me the required output \begin{tikzpicture} \begin{axis}[ybar s

  • Why is my stacked area graph in ggplot2 returned as stacked lines?

    Why is my stacked area graph in ggplot2 returned as stacked lines? September 16

    im having a bit of a problem creating my stacked area chart in ggplot2 in R, for some reason it is returning as a stacked line; eg data: library(ggplot2) Sector <- rep(c("S01","S02","S03","S04","S05",&q

  • ggplot2: how to plot proportional stacked bar graph with countsFebruary 9

    Currently my code below plots the count of cases stratified by columnB and over different years on the x-axis. Instead of actual counts, I would like to plot the proportions of cases. How would I go about and do that? ggplot(df, aes(x= year, fill=col

  • Munin Windows Sum Stack graphFebruary 3

    I am trying to stack multiple graph in one with munin. The idea is to stack all the web servers CPU graph into one graph. Munin configuration source graph: [WEB1.virtualservers] address 10.11.6.72 use_node_name yes memory.swap.label swap memory.swap.

  • Filling Stacked Graph v.10.1

    Filling Stacked Graph v.10.1June 22

    I used a code very similar to the code posted by Kuba stacked line graph with fragmented data TestData = {{{1, 23}, {4, 3}, {10, 34}, {12, 34}, {20, 5}}, {{5, 3}, {6, 3}, {7, 4}, {15, 12}, {21, 5}}}; Plot[Piecewise[{{Interpolation[#, x, Interpolation

  • Nagios Host Stacked GraphsAugust 17

    I've got several identical front end web servers which are monitored by Nagios for various services and host performance stats (application metrics, memory, cpu etc...). I also use the graph explorer component which I really like. I particularly like

  • stacked bar *bringing labels to the graph *

    stacked bar *bringing labels to the graph *February 14

    I'm plotting a stacked bar graph and use geom_text to insert the value and name of each stack. The problem is some stacks are very small/narrow, so that the text of two stacks overlap each other and hence is not very readable. How can I modify the co

  • Single stacked bar, values and legend

    Single stacked bar, values and legendDecember 27

    \documentclass{article} \usepackage{pgfplots} \begin{document} \pgfplotsset{testbar/.style={ title=strookdiagram sporten, xbar stacked, width=10cm, axis y line*= none, axis x line*= bottom, xmajorgrids = true, xmin=0,xmax=100, ytick = data, yticklabe

  • how to display multiple graphs on a single page?

    how to display multiple graphs on a single page?March 25

    I have make a graphic where I need to show user trends. I will call them A, B, C, D -- brands of cell phones. My users are not very good at reading charts. Are there ways to combine features of chart 1 and chart 2 to make a more intiuitive graph? Ver

Copyright (C) 2017 ceus-now.com, All Rights Reserved. webmaster#ceus-now.com 14 q. 0.509 s.