[libreoffice-users] Calc charts, data in record form

All,

Looks like I will be keeping my data in Calc for a while - until we have
a better idea of what we want (changing a database is a lot of work).

However, I need to do some charts, and I have not figured out how to get
Calc to give me what I want, so I need a pointer or two.  I want line
charts, with multiple curves per axis (up to 8).  Perhaps something like
this: http://www.indiabix.com/data-interpretation/line-charts/

The data is arranged in record format like this:

Date      Location  Temperature    Humidity
--------- --------- -------------- ---------
7/1/14    Syracuse              71       79%
7/1/14    Albany                68       70%
7/1/14    Rochester             69       70%
7/8/14    Syracuse              82       68%
7/8/14    Albany                79       67%
7/8/14    Rochester             75       66%

So how do I end up with one chart that shows three curves for the three
cities over time (Location and Date on the X-axis, Temperature on the
Y-axis)?  I have looked at the docs amd did some Googling, but so far
I'm stumped.  I know that someone has done this, so there is likely a
very easy want to do it.

Dave.
-- 
  dave boland
  dboland9@fastmail.fm

-- 
http://www.fastmail.fm - Does exactly what it says on the tin


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted