Plotting XY graph with two values and time

[altenbach]

Here's how the modification should look like (left). Alternatively, you could also read all lines directly (right-click the file read and select "read lines" and wire a -1 to the count terminal) (right).

[Patel33]

I did do that initially but got the same error so i tried something different.

Iv'e attached the original files.

[altenbach]

Well, these files have a completely different data structure and contain significantly more data per line.. You need to adjust the scanning operation dramatically.

[Patel33]

Is it just the format string that needs adjusting or will other parts need to be changed?

Thanks

[altenbach]

My FOR loops process one line at a time. Your lines are 10x longer and much more complicated. You need to adjust the scan format to get the right data. Use my draft as a template.

[Patel33]

It says I have used too many format specifiers, do I need to wire more default value terminals to account for this?

[Patel33]

Nevermind its working now.

What is the input parameter for # ?

[altenbach]

---

Patel33 wrote:

What is the input parameter for # ?

---

You probably need to be more specific that that. 😉

[Patel33]

Well one of the spreadsheet cells contain ###, so I need to specify this in the string function.

[GovBob]

Are you sure the width of the cell is large enough to hold the value. Excel will fill it in with # signs if the cell is too small.