| View previous topic :: View next topic |
| 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. |
|
| Back to top |
|
 |
keme
Moderator
Joined: 30 Aug 2004
Posts: 2732
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. |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
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 http://forum.openoffice.org |
|
| Back to top |
|
|
|
|
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
|
