trouble understanding how to format the time axis for XY graph

[LED47]

I'm kind of new at LabVIEW and I'd like to ask the following question:

dCCT - TLCI-2012 / K	Date
14.42445477	10/11/2022
14.40828187	10/12/2022
14.39765744	10/17/2022
14.3969672	10/24/2022

the following data from Excel I would like to transfer into an XY graph.

(Or waveform chart)

I can send the two columns into a XY graph,

but I don't see how to format the X axis to give me those dates per point?

what I need is the ability to format the X axis in the correct time format.

[ZYOng]

Display Time and Date on a Graph or Chart in LabVIEW

Programmatically Format the X-Axis of a LabVIEW Graph to Display Timestamps 

There is a lot of useful knowledgebase on the NI website. You can try to search from ni.com

[GerdW]

Hi LED,

---

@LED47 wrote:

I can send the two columns into a XY graph,

but I don't see how to format the X axis to give me those dates per point?

---

Like this:

---

@LED47 wrote:

what I need is the ability to format the X axis in the correct time format.

---

It's set in the properties dialog of the graph, in the Display format tab…

[LED47]

thank you that worked very well...

( it would've took me forever to figure that out on my own)

Chris

[altenbach]

Same, but maybe slightly less clutter: 😄

[LED47]

you folks have been really nice I almost feel embarrassed to ask...

When I read the Excel spreadsheet I get the numerical time values..

I don't seem to get the text date values:

Date

10/11/2022

10/11/2022

10/11/2022

10/12/2022

10/12/2022

10/12/2022

10/17/2022

10/17/2022

10/17/2022

10/24/2022

10/24/2022

10/24/2022

[altenbach]

---

@LED47 wrote:

you folks have been really nice I almost feel embarrassed to ask...

When I read the Excel spreadsheet I get the numerical time values..

• How do you read the excel spreadsheet? (read in excel? read in LabVIEW?)
• Is it really excel (proprietary Microsoft file type!) or a tab delimited table string?
• Can you attach the excel spreadsheet?
• How do you write it?

[LED47]

attached both the VI and the spreadsheet I'm reading from

[LED47]

that VI was incomplete, as I was preparing to switch the displays to XY graph..

[altenbach]

Oh wow! You never said anything about excel. Why don't you just export the excel to tab delimited text instead and go from there?

Sorry, I don't "do"" EXCEL, but much of your code is extremely convoluted (too many loops, there is a tool to get the current VI path but you don't even need that, ever heard of autoindexing? etc.).

(In a nutshell... attached is how you would read the exported sheet)