Ask Your Question
0

Can I add arrows to a calc graph?

asked 2019-03-19 11:41:38 +0200

jimberry gravatar image

updated 2019-03-20 00:49:08 +0200

I have uploaded a calc spreadsheet to "http://jimberry.org/files/files.html" It contains an area graph in which I have set transparency to 50% for the data series colours, as I want to see all the values in all 5 layers. This makes the colour coding for the data series legends a little more difficult for a viewer to interpret. Is there any way to insert arrows to point from a legend description to its associated area? Or if not, can the vertical order of the legend be inverted to reflect the graphs appearance?

As a separate query, I can't see how I have managed to get the value of cell C19 printed on the graph?

Ubuntu 17.04 - LibreOffice calc 5.4.3.2

edit retag flag offensive close merge delete

Comments

Regarding the value for C19, did you inadvertently enable "Insert data labels" for that one value?

ve3oat gravatar imageve3oat ( 2019-03-21 00:29:18 +0200 )edit

21/03/2019 - I have now managed to change the area colours so that the overlaid colours (50% transparent) are not as markedly different from the solid opaque colurs in the legend. I would still like to know if it is possible in CALC to add arrows to the calc graph as shown in the attached png file where the arrows were added in LibreOffice DRAW?

jimberry gravatar imagejimberry ( 2019-03-21 03:10:47 +0200 )edit

@ve3oat - that is quite possible - but that stray value has disappeared after adding more "date" rows and changing the legend position to "top"

jimberry gravatar imagejimberry ( 2019-03-21 03:14:28 +0200 )edit

Sorry, I hadn't worked out how to attach a file. The file mentioned in my first comment is at http://jimberry.org/files/march2019en... and I have also included it in the page linked in the original question Sample chart

jimberry gravatar imagejimberry ( 2019-03-24 10:54:50 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2019-03-30 08:54:56 +0200

jimberry gravatar image

I have found a simple solution on page 160 of the official calc guide

Select the Drawing toolbar (View > Toolbars > Drawing) which will appear at the bottom of the spreadsheet. Choose the appropriate arrow from the dropdown selector and draw the arrow where you want it to appear. I have also changed the area colors and transparencies so that they are closer to the solid colors in the legend list.

Here is my example of how to add arrows to a calc chart.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-03-19 11:41:38 +0200

Seen: 72 times

Last updated: Mar 30