Hi Regina and Pedro, > > Technically it is possible, but it is cumbersome and instable. I would > not go that way, but generate a one-dimensional list from the data. > With such list, you can use a real time axis. That's what I figured - so I'll have to have a ghost list somewhere (probably column ZZ way to the right) that is generated from the x,y list.... Perhaps time for an enhancement request ;) I don't think that this set up is all that uncommon for demonstrating a table and wanting to have an accompanying chart. > > Now the technical part: > > Enter category (first) and value (second) manually to the fields in > the data range dialog. > > For example: > > in Category (for 3 years) > $Sheet1.$A$2:$A$13;$Sheet1.$A$2:$A$13;$Sheet1.$A$2:$A$13 > Notice, the same range is repeated. > > in Values (for 3 years) > $Sheet1.$B$2:$B$13;$Sheet1.$C$2:$C$13;$Sheet1.$D$2:$D$13 > > Notice, the parts are connected with semicolon. > > Disable all automatic from the x-axis formatting. Set the type "Date" > and enter the needed min, max and intervals. Set label to 90°. For the > y-axis disable "source format" at tab Number and set to 0 decimals.
I'm going to give this a try just out of curiosity :) Thanks for the detailed explanation. Best, Joel -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
