Home

Line Graph Time Duration

%3CLINGO-SUB%20id%3D%22lingo-sub-815779%22%20slang%3D%22en-US%22%3ELine%20Graph%20Time%20Duration%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815779%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20am%20trying%20to%20chart%20minutes%3Aseconds%20week%20by%20week%20for%20a%20run%20of%2012%20weeks.%26nbsp%3B%20So%20wk1%2030min27secs%2C%20wk%202%2032min35secs%2C%20etc.%26nbsp%3B%20When%20I%20initially%20format%20the%20chart%20data%20as%20%5Bh%5D%3Amm%3Ass%20it%20works%20although%20the%20formula%20bar%20still%20shows%20a%20date(%3F)%20but%20when%20I%20copy%2011%20weeks%20and%20paste%20above%20line%2012%20and%20update%20line%2012%20with%20the%20latest%20week%2C%20it%20changes%20the%20format%20even%20though%20when%20i%20go%20to%20format%20that%20cell%2C%20it%20is%20the%20same%20as%20above.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-815779%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-816040%22%20slang%3D%22en-US%22%3ERe%3A%20Line%20Graph%20Time%20Duration%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-816040%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396195%22%20target%3D%22_blank%22%3E%40Randel2001%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhere%20exactly%20format%20is%20changed%20and%20on%20what%3F%20In%20your%20file%20all%20looks%20correct%20except%20one%20cell%20which%20is%20entered%20as%20text%2C%20not%20time.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20366px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127898i885D3DC143350310%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Randel2001
Occasional Visitor

i am trying to chart minutes:seconds week by week for a run of 12 weeks.  So wk1 30min27secs, wk 2 32min35secs, etc.  When I initially format the chart data as [h]:mm:ss it works although the formula bar still shows a date(?) but when I copy 11 weeks and paste above line 12 and update line 12 with the latest week, it changes the format even though when i go to format that cell, it is the same as above. 

1 Reply

@Randel2001 

Where exactly format is changed and on what? In your file all looks correct except one cell which is entered as text, not time.

image.png

Related Conversations