Download it now!
Bug 66250 - Use a Named range as data source for Chart
Summary: Use a Named range as data source for Chart
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 132647 (view as bug list)
Depends on:
Blocks: Chart-Enhancements Chart-Data Cell-Name
  Show dependency treegraph
 
Reported: 2013-06-27 10:28 UTC by Pedro
Modified: 2020-05-14 00:38 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Pedro 2013-06-27 10:28:47 UTC
This has been a long standing limitation in OOo and now LO.

You can use Named ranges as source for Pivot tables but not for charts. 

This would allow to have charts defined for later data input (currently that is not possible because the data range is automatically reduced to cells containing data)

See this topic as an example (there are many others)
http://ask.libreoffice.org/en/question/19627/calc-charts-automatically-increasing-data-range/
Comment 1 Owen Genat (retired) 2014-07-05 00:57:45 UTC
Added related Apache OO issue to See Also list. Version set to Inherited from OOo.
Comment 2 Owen Genat (retired) 2014-07-05 01:34:51 UTC
A workaround is to select an additional empty row (above and below) for the Data Range and ensure this option is selected: 

Tools > Options > LibreOffice Calc > General > Input Setting > Expand references when new columns/rows are inserted

Inserting a new row beneath the last row will then automatically update the chart as expected. Same effect if inserting a new row prior to first row of data.
Comment 3 Pedro 2014-07-05 06:39:20 UTC
(In reply to comment #2)
> Inserting a new row beneath the last row will then automatically update the
> chart as expected. Same effect if inserting a new row prior to first row of
> data.

Thanks. I already do that. But I hope that someone actually adds this feature. It doesn't make sense that you can use Named ranges for some features but not for others. It's inconsistent and unintuitive ;)
Comment 4 Regina Henschel 2016-02-20 18:53:11 UTC
This issue is connected to bug 64086. The missing ODF feature is handled in https://issues.oasis-open.org/browse/OFFICE-2081
Comment 5 Timur 2020-05-04 02:00:36 UTC
*** Bug 132647 has been marked as a duplicate of this bug. ***