1 Reply Latest reply: Dec 22, 2013 5:06 PM by Barry
amg81899 Level 1 (0 points)

When I try clicking line graph, it shows me an empty graph.....no data on it.....just an x and y axis


MacBook Air, OS X Mavericks (10.9)
  • Barry Level 7 (29,990 points)

    Convert your Duration values to numerical equivalent using DUR2MINUTES. Chart the values in the converted column, as shown:

    Screen Shot 2013-12-22 at 5.01.48 PM.png

    Chart 1: Result when cells containig duration values (column C) are selected and charted.

    Chart 2: Result for same type of chanrt with same rows of column D are selected.

     

    D2, and filled down: =DUR2MINUTES(C)

     

    Regards,

    Barry