Alternative charts

Is it possible to use the chart capabilities of R to work directly on libre-office spreadsheets? I mean, ideally, in the sense of being able to run macros to set up R charts live from an open spreadsheet.

I am using LibreOffice 5.1.4.2 on Linux Mint.