Adding events into a libreoffice calc graphic

users
#1

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?

#2

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.