[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [libreoffice-users] Adding events into a libreoffice calc graphic


Hi,

I never was able to mix text and numbers on a single graph, so placing
the event as part of the data may not work. There is a workaround,
though. Plot your data points without placing the event text in the
data, but a corresponding event value (or some acceptable in-between
value). Then, go to edit the graph (right click > Edit), and then click
twice (not double click: click once, count 1 sec, then click again) on
the datapoint where you want to place the event text. After the two-
click, the data point should have a set of green dots around it showing
it has been selected. Right click on it, and then select "Insert single
data label". The value of the data label will now be shown. Then right
click again and select "Format single data label...". Go to the Data
Labels tab and check the "Show value as Number" box; then click on the
"Number format..." button. In the Format code box, place the name of
the event in quotes (like "Event name") and click the green check
button. Then OK, and OK again. Your data point should now have a label
saying Even name. You can then do this for all event-related data
points.

I hope this helps.

Rémy.

Le samedi 13 avril 2019 à 10:39 -0700, TheJoe a écrit :
> Hi everybody, and thank you for the support, I've looked arround for an
> answer for a few hours without success.
>
> We're talking about LibreOffice Calc:
>
> What i'm about to do is a data table with two columns: "date" and "numeric
> data". After that i would insert a graphic in the spreadsheet ("insert" -
> "graphic"). And for now no problems.
>
> Now i have to add some non-numeric "events" to the graphic. For example:
> 10/3/2019 - 225
> 15/3/2019 - event
> 20/3/2019 - 353
> 22/3/2019 - 50
>
> and so on...
>
> Now it happens that in the graphic the line that connects all the points
> breaks at 15/3/2019 and starts again at 20/3/2019. I would like to add this
> information in the graphic with a line that points to the right point on the
> graphic.
>
> Is it possible or i am dreaming?
>
>
>
> --
> Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
>
>

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.