How do I create a line graph in numbers if my y values are in minute/second format?
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)
Convert your Duration values to numerical equivalent using DUR2MINUTES. Chart the values in the converted column, as shown:
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