OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

multi series chart?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
peter360
Newbie
Newbie


Joined: 20 Sep 2009
Posts: 1

PostPosted: Sun Sep 20, 2009 8:09 pm    Post subject: multi series chart? Reply with quote

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.
Back to top
View user's profile Send private message
keme
Moderator
Moderator


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

PostPosted: Sun Sep 20, 2009 10:58 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Sep 20, 2009 11:12 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group