How To Graph Minutes On Excel

Copper Contributor

I'm trying to graph the time termites spent on a pattern of a path with a pen. I made a custom cell style with it being minutes and seconds but when I highlight the cells to graph them the recommended charts says "there are no recommended charts for the data I selected" What I'm i doing wrong?

@links to members

2 Replies

@miguel7carranza 

Have you tried selecting a line chart or XY scatter chart instead?

@miguel7carranza 

Scatter chart shall work, other ones work with days and minutes axis will be taken as text axis.