add data series to existing chart from 2nd sheet

asked 2019-02-09 16:26:44 +0100

benchrest gravatar image

updated 2019-02-09 18:33:55 +0100

With I cannot add a new data series to a chart if the data series is on another sheet from that file. It does work if the data series is on the same sheet. This works on . Has this operation changed? I double click for edit mode, select data ranges, data series, add, select range for name, click on cell in other sheet for name and nothing happens. Also fails in safe mode. Since 5.4 I have found serious issue with each new release keeping me on 5.4. The bad thing is I don't see others having same problems. During this time I have reinstalled Linux Mint and should have cleared OS problems. Any ideas? ADDITION: In creating a simple spreadsheet to submit a bug. I found it does fail doing my method of having both the sheet with the chart and the sheet with the data open. However having only one sheet open and selecting the 2nd sheet when needed it works. I will do more testing.

edit retag flag offensive close merge delete