BACKGROUND:
I am a very experienced user of LO - and formerly OOo and before that StartOffice from when Sun bought it . Over the years I have done statistical analyses of the performance of a mega-large hetrogenous network, and have produced conservatively 200-300 complex charts for each monthly report for over 23 years (before LO/OOo/SO I was using Nroff/Troff on Unix, Solaris, and Linux machines). These reports typically run from 500-1100 pages and are ultimately assembled in Writer with the charts coming from scalc.
MACHINE/OS PARTICULARS:
I am using LO 5.0.6 on a Linux machine (Fedora FC24) on an Intel i7 machine with 12 cpus and 32 GB memory, so there are few if any resource limitations.
PROBLEM:
I have a financial spreadsheet with a chart in which I wish to change the data range. Oddly enough the old 3.x method (How can I expand a chart's data range?) usually fails because when I select the format tab, the item for “Data Ranges” is grayed out and cannot be selected.
Is editing the data range no longer supported, or is it just the case that 75%+ of the charts I create are exceptions?
Of course I can always delete the chart and recreate it and recreate it to get the correct data range, but since I must do this on a VERY large number of charts it is far more time-consuming that it would be if there were a reliable way to use the menu option.
If the function is still supported then I need help to figure out what is going wrong here. Unfortunately I cannot post one of the actual charts because they all cover sensitive, proprietary data.
Any help would be greatly appreciated.