 |
|
You are not logged in! F.A.Q Log in Register |
 |
|
 |
 (nobody)...and 581 guests Last 5 registered Oplandisks nothingstar N_loop yipe foxtrotromeo Browse members... |
 |
Members 8025Messages 2614087 Today 0 Topics 127542 |
|
|||||||||
| |||||||||
|
|
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! |
||||||||
|
|
|||||||||
| |||||||||
|
|
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 |
||||||||
|
|
|||||||||
| |||||||||
|
|
it's alri i got it, cheers |
||||||||
|
|
|||||||||
|
Messageboard index
|
|||||||||
