| View previous topic :: View next topic |
| Author |
Message |
soop
Newbie
Joined: 27 Jun 2006
Posts: 1
|
 Posted: Tue Jun 27, 2006 2:46 pm Post subject: Help Creating Charts |
 |
|
Hi, ok I've got a spreadsheet that creates charts for required horse power for appropriate discharge pressure based on rpm.
The spreadsheet was initially created in excel and then when opened in OpenOffice they lose the additional data sets
see the attached files ....
This is what it is supposed to look like:
Here is the original file:
http://www.thundercity.ca/matt/spreadsheet.xls
What I'm trying to do is figure out how to plot HP Required For Dischargepressure for each of the designated RPMs
2000 RPM Requires 40 Horsepower for a discharge pressure of 150
1600 RPM requires 32 Horsepower for a discharge pressure of 150
etc.
Any ideas? the whole graph/chart wizard is throwing me for a loop |
|
| Back to top |
|
 |
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Wed Jun 28, 2006 6:25 am Post subject: Re: Help Creating Charts |
|
|
| soop wrote: | Hi, ok I've got a spreadsheet that creates charts for required horse power for appropriate discharge pressure based on rpm.
The spreadsheet was initially created in excel and then when opened in OpenOffice they lose the additional data sets
see the attached files ....
This is what it is supposed to look like:
What I'm trying to do is figure out how to plot HP Required For Dischargepressure for each of the designated RPMs
2000 RPM Requires 40 Horsepower for a discharge pressure of 150
1600 RPM requires 32 Horsepower for a discharge pressure of 150
etc.
Any ideas? the whole graph/chart wizard is throwing me for a loop |
I am not sure what you want here. This is partly due to the fact that for some reason your message is blown up to some unreasonalble size on my machine. I think it is my problem not yours.
Otherwise when I look at the Excel file I don't see any those multiple line graphs. Just what is diappearing? Are you trying to graph a number of Discharge Presssure curves? That is, you want a line fore 150 , one for 250 etc on the same graph?
If so, it is a bugger to do in Calc given the way your data is arranged. To do it properly I think you would have to have the rpms as your leftmost column and the hp's arranged by DP giving you something like:
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
|
