Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to create a chart on a data series in Calc, and then unlink it so that if I sort that same data a different way, my chart wont change?

i am trying to show some trends based on several different factors all coming from the same data set.

share|improve this question
up vote 1 down vote accepted

AFAIK unlinking isn't possible, but why not copying the complete sheet? This way, you get a second/third copy of your data series without manually selecting / copying / inserting the data anywhere else.

copy sheet menu

copy sheet dialogue

share|improve this answer
Please make sure in the copying sheet you see DataRange option. If you see DataTable which is embedded with the chart, the work around will not work!!. – Monir Jan 25 '15 at 11:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.