[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
peter360
Newbie

Joined: 20 Sep 2009
Posts: 1

Posted: Sun Sep 20, 2009 8:09 pm    Post subject: multi series chart?

Let's say I have multiple cities where the temperatures are periodically measured. Let's say we got the following data

 Code: city,time,temperature Seattle,08:00,50 Seattle,10:00,55 Seattle,12:00,60 ... Denver,08:30,40 Denver,10:30,45 Denver,12:30,50 ... New York,08:30,55 New York,09:30,60 New York,10:30,60 ...

I want to plot each city as a time series in the same chart, with X-axis being the time, Y-axis being the temperature and cities being color coded. Is that doable in calc?

Note: the measurement times in different cities are not the same. Thanks.
keme
Moderator

Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

 Posted: Sun Sep 20, 2009 10:58 pm    Post subject: Shouldn't be any problem. Use an x-y chart, and link in data for each city as a new data range. Use the measurement times for X range in the series, and measured value as the Y range. Post again if you need more detail, or this doesn't cover your requirement. Edit the first post of the thread and add [SOLVED] if the problem is solved.
Villeroy
Super User

Joined: 04 Oct 2004
Posts: 10106
Location: Germany

Posted: Sun Sep 20, 2009 11:12 pm    Post subject:

Create a data pilot with times vs cities and the average of temperatures in the center. If there is more than one value for the same time and city, the average should be the best aggregation.
The pilot (without totals) from the above data looks like:
 Code: Average - Temp   City       Time   Denver   New York   Seattle 08:00:00         50 08:30:00   40   55    09:30:00      60    10:00:00         55 10:30:00   45   60    12:00:00         60 12:30:00   50

Draw your chart from that table.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum