Chart with 1 millisecond as interval on x axis

%3CLINGO-SUB%20id%3D%22lingo-sub-278262%22%20slang%3D%22en-US%22%3EChart%20with%201%20millisecond%20as%20interval%20on%20x%20axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278262%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20draw%20a%20graph%20with%201%20millisecond%20interval%20is%20that%20possible%3F%20If%20i%20use%20scatter%20plot%20to%20draw%20time%20series%20graph%20it%20is%20considering%20it's%20own%20values%20without%20taking%20the%20original%20data%20from%20the%20excel%2C%20how%20to%20change%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-278262%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1443788%22%20slang%3D%22en-US%22%3ERe%3A%20XY%20Chart%20with%20custom%20date%20and%20time%20as%20interval%20on%20x%20axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1443788%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F234508%22%20target%3D%22_blank%22%3E%40Management%20Information%20System%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20chart%20will%20not%20accept%20the%20date%2Ftime%20data%20from%20the%20spreadsheet%20for%20the%20X%20axis.%26nbsp%3B%20It%20uses%20it's%20own%20data%20starting%20with%20Sat%20Jan%2000%200%3A00%3A00%201900.%26nbsp%3B%20I%20have%20used%20a%20custom%20format%20for%20the%20cells%20in%20the%20spreadsheet%20and%20as%20the%20X-axis%20format%20in%20the%20chart%20as%20ddd%20mmm%20dd%20h%3Amm%3Ass%20yyyy.%26nbsp%3B%20My%20data%20in%20the%20spreadsheet%20starts%20as%26nbsp%3BThu%20Apr%2016%2014%3A48%3A51%202020.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1443816%22%20slang%3D%22en-US%22%3ERe%3A%20XY%20Chart%20with%20custom%20date%20and%20time%20as%20interval%20on%20x%20axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1443816%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F690540%22%20target%3D%22_blank%22%3E%40Thomas357%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EScatter%20chart%20work%20with%20dates.%20What%20you%20see%20in%20X%20axis%20are%20sequential%20numbers%201%2C2%2C3%20formatted%20as%20dates.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%20this%20thread%20with%20workarounds%2C%20that's%20close%20to%20your%20issue%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fquestions%2F51477752%2Fhow-can-i-plot-time-in-the-x-axis-of-a-scatter-plot-in-excel%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fstackoverflow.com%2Fquestions%2F51477752%2Fhow-can-i-plot-time-in-the-x-axis-of-a-scatter-plot-in-excel%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Regular Visitor

I need to draw a graph with 1 millisecond interval is that possible? If i use scatter plot to draw time series graph it is considering it's own values without taking the original data from the excel, how to change that?

2 Replies
Highlighted

@Management Information System 

My chart will not accept the date/time data from the spreadsheet for the X axis.  It uses it's own data starting with Sat Jan 00 0:00:00 1900.  I have used a custom format for the cells in the spreadsheet and as the X-axis format in the chart as ddd mmm dd h:mm:ss yyyy.  My data in the spreadsheet starts as Thu Apr 16 14:48:51 2020.

Highlighted

@Thomas357 

Scatter chart work with dates. What you see in X axis are sequential numbers 1,2,3 formatted as dates.

 

Please check this thread with workarounds, that's close to your issue https://stackoverflow.com/questions/51477752/how-can-i-plot-time-in-the-x-axis-of-a-scatter-plot-in-...