|
|
|
PORICK
from fucking IRELAND on 2008-09-15 12:25 [#02236897]
Points: 1911 Status: Lurker
|
|
Hello,
I'm using openoffice to plot a graph of values from a total of 29 spreadsheets. The values I need plotted are all in the first row of each sheet. Therefore my syntax is:
$Sheet1.$A$1:$Z$1;$Sheet2.$A$1:$Z$1;$Sheet3.$A$1:$Z$1;$Shee t4.$A$1:$Z$1;$Sheet5.$A$1:$Z$1;$Sheet6.$A$1:$Z$1;$Sheet7.$A $1:$Z$1;$Sheet8.$A$1:$Z$1;$Sheet9.$A$1:$Z$1;$Sheet10.$A$1:$ Z$1;$Sheet11.$A$1:$Z$1;$Sheet12.$A$1:$Z$1;$Sheet13.$A$1:$Z$ 1;$Sheet14.$A$1:$Z$1;$Sheet15.$A$1:$Z$1;$Sheet16.$A$1:$Z$1; $Sheet17.$A$1:$Z$1;$Sheet18.$A$1:$Z$1;$Sheet19.$A$1:$Z$1;$S heet20.$A$1:$Z$1;$Sheet21.$A$1:$Z$1;$Sheet22.$A$1:$Z$1;$She et23.$A$1:$Z$1;$Sheet24.$A$1:$Z$1;$Sheet25.$A$1:$Z$1;$Sheet 26.$A$1:$Z$1;$Sheet27.$A$1:$Z$1;$Sheet28.$A$1:$Z$1;$Sheet29 .$A$1:$Z$1
However, the problem is with how I need these values to be plotted. I am plotting a scatter line graph, and the values from each spreadsheet need to be plotted on their own individual line, with its individual colour.
Could someone reccomend settings to use in the Wizard in order to achieve this? If necessary, I'll post screenshots of what options are available to me.
Currently, I'm only able to get all of the values from all of the spreadsheets plotted on a single line.
Any help would be greatly appreciated. Cheers!
|
|
goDel
from ɐpʎǝx (Seychelles) on 2008-09-15 12:44 [#02236905]
Points: 10225 Status: Lurker
|
|
there should be some add new domain function somewhere in the wizard. but you probably have to add them individually.
i don't have exp with openoffice though. only microbloft
|
|
PORICK
from fucking IRELAND on 2008-09-15 13:08 [#02236912]
Points: 1911 Status: Lurker
|
|
it's alri i got it, cheers
|
|
Messageboard index
|
|
|
|