Received: by 10.66.75.164 with SMTP id d4mr2665013paw.10.1352071005247; Sun, 04 Nov 2012 15:16:45 -0800 (PST)
Received: by 10.68.141.45 with SMTP id rl13mr1692922pbb.8.1352071005225; Sun, 04 Nov 2012 15:16:45 -0800 (PST)
Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!news.linkpendium.com!news.linkpendium.com!news.snarked.org!newsfeed.news.ucla.edu!usenet.stanford.edu!kt20no31563873pbb.1!news-out.google.com!6ni57209pbd.1!nntp.google.com!kt20no31563872pbb.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.graphics.apps.gnuplot
Date: Sun, 4 Nov 2012 15:16:44 -0800 (PST)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=98.234.174.214; posting-account=KXGM2goAAABCRD2Ngk6bmv3Db6IAfCLl
NNTP-Posting-Host: 98.234.174.214
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <6d2d9f74-3046-4a0d-ba73-fa4c1c833a2d@googlegroups.com>
Subject: Skipping data file with no valid points
From: erikzweigle@gmail.com
Injection-Date: Sun, 04 Nov 2012 23:16:45 +0000
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Xref: csiph.com comp.graphics.apps.gnuplot:1464

Hello,

I have a single .xlsx file that contains the data I'd like to plot.  After =
reading Gnuplot in Action I only see Janert using .dat & .txt file formats.=
  So, on my mac I 'save as' to .txt 'tab delimited' (as opposed to the othe=
r two .txt options of MS-DOS & Windows formatted).  Then I navigate to the =
directory of interest in Terminal, launch gnuplot and type -- plot "trial.t=
xt" u 1:3 w lp  -- with no luck (warning: Skipping data file with no valid =
points).

I tried adding a # to the first line.  I tried alternative .txt formats.  I=
 manually re-created the first ten entries in my TextEdit app only to find =
out there is no save as option for .txt files (wtf?).  Then I re-created in=
 Xcode which saved it with no file extension BUT it plots as expected.  Cop=
ying and pasting from the xlsx file into a blank Xcode file and saving also=
 works as expected. =20

Can someone provide pointers so that I do not have to do this each time I w=
ant to play with my data?

In case it was not obvious, I am within my first 4 hours learning gnuplot -=
 and Janert's book is great but I'm having trouble getting going with real =
data sets I'd like to analyze.

Thanks.