How To Graph Minutes On Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2420119%22%20slang%3D%22en-US%22%3EHow%20To%20Graph%20Minutes%20On%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2420119%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20graph%20the%20time%20termites%20spent%20on%20a%20pattern%20of%20a%20path%20with%20a%20pen.%20I%20made%20a%20custom%20cell%20style%20with%20it%20being%20minutes%20and%20seconds%20but%20when%20I%20highlight%20the%20cells%20to%20graph%20them%20the%20recommended%20charts%20says%20%22there%20are%20no%20recommended%20charts%20for%20the%20data%20I%20selected%22%20What%20I'm%20i%20doing%20wrong%3F%3C%2FP%3E%3CP%3E%40links%20to%20members%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2420119%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2420216%22%20slang%3D%22en-US%22%3ERe%3A%20How%20To%20Graph%20Minutes%20On%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2420216%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1072251%22%20target%3D%22_blank%22%3E%40miguel7carranza%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHave%20you%20tried%20selecting%20a%20line%20chart%20or%20XY%20scatter%20chart%20instead%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.