Chart wizard goes red when entering ranges

[rlaggren]

Edit- add system detail:
OpenSuse 15.2
LO 7.1.4.2

I have spent more than an hour trying to get ChartWizard to make a simple x:y chart. A major problem is the range fields go red when I enter what seems to me totally correct ranges. For example, data range:
$A$1:$D$40 (this specs a small subset of the data)

Or again for an x-axis: $A$1:$A$40 (again, a small subset)

Prefixing sheet names doesn’t matter. I have not idea and can find no explanation for this problem - that syntax I use appears exactly the same as in examples which presumably work. Rarely, it seems to work for one field; then fails for another.

I prefer to define functions and enter data with the keyboard and thus I do NOT select an active cell within the data ranges. As far as I know that should never be needed, and it doesn’t seem to help anyway.

One reason that I don’t want ChartWizard to try to guess ranges: I have 40k lines of raw data and LO and ChartWizard don’t handle that quickly - in fact, they seem to want to crash. I hope to define the chart using smaller portions of that data and I guess given the problems I’ve had, I’ll just extract a couple dozen lines to a separate spreadsheet. But I doubt that will resolve my problem with ChartWiz rejecting my range specs.

What (likely very simple thing) am I missing here?

Thanks,
Rufus

[LeroyG]

@rlaggren

Prefixing sheet names doesn’t matter.

Not for me. So, add the “Sheet1.” (or whatever sheet name) before.

Tested with LibreOffice 7.1.8.1.

See Chart Wizard - Data Range.

[joshua4]

Notice that is “Sheet1.” I could see myself using “Sheet1!” by habit from Excel.

[rlaggren]

I extracted a small set to a test sheet and can now define ranges. Don’t know results on the main sheet yet, still need to switch axis and generally make a chart. But the original pothole is passed. So: Solved

Thanks
Rufus