Ask Your Question

Libreoffice 6: using named ranges in charts?

asked 2018-08-16 17:35:54 +0200

erotavlas gravatar image


I already read here and here about using named ranges in chart. For what I understood is still not possible even after 5 years with libreoffice 6.x.

Do you confirm this?

My problem is that I have two calc sheets: the first is the one with formulas and charts while the second contains data updated from Internet via a script. The first sheet gets the data (indexed by the date and the columns can have different length during the various updates) from the second one and automatically updates the calculation.

Unfortunately, the charts ranges are not updated according to the updated data. I cannot use any function as

match, address, offset, vlookup.

Is there any workaround?

Thank you

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-08-18 00:01:38 +0200

m.a.riosv gravatar image

updated 2018-08-27 11:32:27 +0200

Maybe using pivot chart you can achieve what you want.

Creating a pivot table and then while in a cell of it creating a chart.

Edited 20180827

Attached a sample file with a pivot chart, it's possible to use the filters on the pivot table or those on the chart after double click.


Creating pivot chart help

edit flag offensive delete link more


Could you provide some examples? Thank you

erotavlas gravatar imageerotavlas ( 2018-08-26 17:07:56 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-16 17:35:54 +0200

Seen: 210 times

Last updated: Aug 27 '18