Ask Your Question
0

Libreoffice 6: using named ranges in charts?

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

erotavlas gravatar image

Hi,

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
0

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

m.a.riosv gravatar image

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

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.

PivotChartSample

Creating pivot chart help

edit flag offensive delete link more

Comments

Could you provide some examples? Thank you

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

Question Tools

1 follower

Stats

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

Seen: 72 times

Last updated: Aug 27 '18