Excel - plotting time elapsed.

%3CLINGO-SUB%20id%3D%22lingo-sub-1938982%22%20slang%3D%22en-US%22%3EExcel%20-%20plotting%20time%20elapsed.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938982%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20I%20would%20love%20some%20help.%3C%2FP%3E%3CP%3EI%20am%20plotting%20'time%20elapsed'%20vs%20other%20values.%3C%2FP%3E%3CP%3EAll%20of%20my%20data%20series%20have%20different%20values%20(I%20have%20about%206%20data%20series)...%20but%20they%20all%20the%20values%20for%20x%20axis%20(time%20elapsed)%20are%20in%20%5Bt%5D%3Amm%20format%20so%20I%20could%20go%20over%2024%20hours....%3C%2FP%3E%3CP%3EAnyway%20it%20is%20looking%20OK%2C%20but%20I%20think%20my%20x%20axis%20is%20displaying%20the%20data%20in%20days%20not%20hours%20as%20it%20goes%20just%20a%20little%20over%201.%20What%20to%20do%20%3F%20How%20to%20fix%20it%3F%3C%2FP%3E%3CP%3EAny%20help%20appreciated.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1938982%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1940026%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20-%20plotting%20time%20elapsed.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1940026%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F884993%22%20target%3D%22_blank%22%3E%40Annmou77%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend%20you%2C%20add%20a%20file%20(without%20sensitive%20data)%20to%20your%20project.%3C%2FP%3E%3CP%3EExplain%20your%20plans%20in%20relation%20to%20this%20file.%20So%20you%20can%20get%20a%20solution%20that%20is%20tailored%20to%20your%20needs%20much%20faster.%3C%2FP%3E%3CP%3EAt%20the%20same%20time%2C%20it%20is%20much%20easier%20for%20someone%20who%20wants%20to%20help%20understand%20the%20subject.%3C%2FP%3E%3CP%3EA%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3EPlease%20no%20Picture%2C%20even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Knowing%20the%20operating%20system%20would%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

 

Hi, I would love some help.

I am plotting 'time elapsed' vs other values.

All of my data series have different values (I have about 6 data series)... but they all the values for x axis (time elapsed) are in [t]:mm format so I could go over 24 hours....

Anyway it is looking OK, but I think my x axis is displaying the data in days not hours as it goes just a little over 1. What to do ? How to fix it?

Any help appreciated. 

 

 

 

2 Replies

@Annmou77 

With your permission, if I can recommend you, add a file (without sensitive data) to your project.

Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

 

* Knowing the operating system would also be an advantage.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

@Annmou77 

In Excel charts x-axis formatted as date axis works with dates only. The workaround is to use scatter chart having axis as numbers and taking into account that date is integer part of number (one day = 1) and time is decimal part. More details here graph - Plotting time on X axis in excel - Stack Overflow and you may google for more samples.