Re: [libreoffice-users] Re: Linear Graph with X,Y data

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: users+unsubscribe@global.libreoffice.org
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