We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calc charts: switch from data table to range as data source?

asked 2020-06-05 11:51:47 +0200

garaolaza gravatar image

updated 2021-05-27 11:50:45 +0200

Alex Kemp gravatar image


Is there any way to switch the data source in a Calc chart so that it lets me select a range instead of a data table?

I spent a long time formatting very specifically a chart, now I want to reuse it somewhere else and I only get the data table editing option.

edit retag flag offensive close merge delete


Do you mean that you had prepared a chart in, say, Writer, and now you copy it into Calc, and want it to use some cell range in Calc?

Then try to select the range in Calc, and drag-and-drop onto the copied chart,

Mike Kaganski gravatar imageMike Kaganski ( 2020-06-05 12:29:51 +0200 )edit

Thank you Mike! I never imagined that it would work that way (and so easily). Thank you very much! You just saved me much time!

garaolaza gravatar imagegaraolaza ( 2020-06-05 12:35:52 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-06-05 13:07:47 +0200

Making my comment an answer, since it apparently had helped:

To change an existing data source of a chart to a cell range from the Calc spreadsheet where this chart had been copied to (from, say, Writer), you need to select the cell range that should be the new data source, and drag-and-drop it onto the chart.

image description

Another option (in recent versions of LibreOffice) is to select Data Ranges context menu item in the chart (above the Data Table item) to drop internal data table and define a new data range from the spreadsheet.

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-06-05 11:51:47 +0200

Seen: 324 times

Last updated: Jun 05 '20