Ask Your Question
0

Can I set a chart's 'data ranges' relative to current sheet?

asked 2016-08-03 03:27:23 +0200

jdpipe gravatar image

updated 2016-08-03 03:27:42 +0200

I would like to create a chart that makes use of data on the current sheet, and then copy/paste the chart to another sheet, and have it link immediately to the new sheet instead of the sheet that the chart came from.

I found the LO (5.1.4.2) lets me remove the '$' from the sheet-name for the series name, X-values and Y-values (enter chart->Format->Data Ranges), so I thought this was looking good.

But when I copy/paste the figure into a new sheet, the '$' is back again, and the data ranges all point to the original data on the original sheet again.

This is bug, right? If I write a formula "=thissheet.$A$1" in thissheet and then copy/paste into thatsheet, then the formua in the pasted sheet becomes "=thatsheet.$A$1". When I copy/paste a chart, the same should happen, right? It shouldn't silently add dollar signs...?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-08-03 05:01:25 +0200

mark_t gravatar image

I could only temporarily remove the $ symbol from sheet name in the data range, after closing data range dialog and then re-opening data range the $ symbol is back even without copying the chart to another sheet.

What did seem to work was to copy the chart to the other sheet, then edit the sheet name in the data range of the copied chart to that of the new sheet.

I'm also using 5.1.4.2

edit flag offensive delete link more

Comments

Yes, that works, but it's still a bug, right? It means explicitly-stated relative references are being deliberately ignored when figures are cut/pasted between sheets.

jdpipe gravatar imagejdpipe ( 2017-01-11 03:44:51 +0200 )edit

I have the same issue (6.1.5). Even when I copy the entire sheet, I cannot rely upon what the range will be. Sometimes it changes to the new sheet, sometimes it remains with the previous sheet. I can edit the sheet name in the data range, but this becomes really tedious.

kws gravatar imagekws ( 2019-02-19 20:46:29 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2016-08-03 03:27:23 +0200

Seen: 170 times

Last updated: Aug 03 '16