Ask Your Question

How do I insert named ranges in charts? [closed]

asked 2013-04-23 09:55:17 +0100

TJ Meneses gravatar image

updated 2020-07-21 19:21:58 +0100

Alex Kemp gravatar image

I've been working on a series of spreadsheets with the same type of data (they're outputs of benchmarking data for my videocard), and have been experimenting on how to streamline my workflow.

I've recently attempted to make named database ranges for each of my 10,000's-of-rows data columns in lieu of manually selecting them for the data selection part of the chart wizard. Alas, it seems it's not as intuitive as I first thought.

How can I make use of the named ranges I made to easily plug into a new chart? Is it even possible?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-28 20:27:50.471429


I have planned to fix that for some time and hope to fix it finally as part of some major chart rework for 4.3 Before that it is sadly not possible to use range names in charts.

moggi gravatar imagemoggi ( 2013-10-28 01:28:21 +0100 )edit

@moggi I downloaded the current 4.4 build (, Build-ID: c4c7d...) and there is not yet a possibility to use range names in charts D:

matteo.bonaker gravatar imagematteo.bonaker ( 2015-04-07 16:36:10 +0100 )edit

me too, it is not possible! :(

estatistics gravatar imageestatistics ( 2015-12-24 01:06:41 +0100 )edit

@moggi@matteo.bonaker I'm using libreoffice (Build ID: 1:6.0.6-0ubuntu0.16.04.1), but I could not find how to achieve it.

erotavlas gravatar imageerotavlas ( 2018-08-16 17:12:56 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-10-27 22:16:24 +0100

hernan gravatar image

updated 2014-07-05 03:01:06 +0100

oweng gravatar image

It is not currently possible to use named ranges in charts. The related enhancement request is fdo#66250 (Apache OO issue aoo#64604). Refer related question here.

edit flag offensive delete link more


A workaround is to select an additional row (above and below) for the Data Range and ensure the option described in this answer is selected. Inserting a new row beneath the last row will automatically update the chart as expected.

oweng gravatar imageoweng ( 2014-07-05 03:28:28 +0100 )edit

Question Tools

1 follower


Asked: 2013-04-23 09:55:17 +0100

Seen: 3,904 times

Last updated: Jul 05 '14