Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

That's a great solution by @pierre-yves samin . However, the capabilities of text tables are limited and some of the Chart features may only work in Calc - or at least better.

Therefore I would like to hint that also a spreadsheet document can be linked into a text document as an OLE object, and if it contains a chart in the saved view, this chart will also show in the 'Writer' document. You can even edit the sheets - not the charts - in Writer and save the changes back to the source file. To edit the charts you need to open the spreadsheet document.

Some time ago I posted this answer to a related question in the German branch. If you cannot understand it there, the attached demo ask100415Demo_1.zip.odg may help you. You need to expand both files contained in the zip into the same folder. To get the archive through the filter I appended the fake extension .odg. Simply remove it again. Open the .odt then.

That's a great solution by @pierre-yves samin samyn . However, the capabilities of text tables are limited and some of the Chart features may only work in Calc - or at least better.

Therefore I would like to hint that also a spreadsheet document can be linked into a text document as an OLE object, and if it contains a chart in the saved view, this chart will also show in the 'Writer' document. You can even edit the sheets - not the charts - in Writer and save the changes back to the source file. To edit the charts you need to open the spreadsheet document.

Some time ago I posted this answer to a related question in the German branch. If you cannot understand it there, the attached demo ask100415Demo_1.zip.odg may help you. You need to expand both files contained in the zip into the same folder. To get the archive through the filter I appended the fake extension .odg. Simply remove it again. Open the .odt then.

That's a great solution by @pierre-yves samyn . However, the capabilities of text tables are limited and some of the Chart features may only work in Calc - or at least better.

Therefore I would like to hint that also a spreadsheet document can be linked into a text document as an OLE object, and if it contains a chart in the saved view, this chart will also show in the 'Writer' document. You can even edit the sheets - not the charts - in Writer and save the changes back to the source file. To edit the charts you need to open the spreadsheet document.

Some time ago I posted this answer to a related question in the German branch. If you cannot understand it there, the attached demo ask100415Demo_1.zip.odgask100415Demo_1.zip may help you. You need to expand both files contained in the zip into the same folder. To get the archive through the filter I appended the fake extension .odg. Simply remove it again. Open the .odt then.

That's a great solution by @pierre-yves samyn . However, the capabilities of text tables are limited and some of the Chart features may only work in Calc - or at least better.

Therefore I would like to hint that also a spreadsheet document can be linked into a text document as an OLE object, and if it contains a chart in the saved view, this chart will also show in the 'Writer' document. You can even edit the sheets - not the charts - in Writer and save the changes back to the source file. To edit the charts you need to open the spreadsheet document.

Some time ago I posted this answer to a related question in the German branch. If you cannot understand it there, the attached demo ask100415Demo_1.zip may help you. You need to expand both files contained in the zip into the same folder. To get the archive through the filter I appended the fake extension .odg. Simply remove it again. Open the .odt then.

then.

(Editing to attach the demo announced in my recent comment to the fake answer by @Thomas:)
Attachment demonstrating what I would suggest ignoring one of the OQ's requirements.

That's a great solution by @pierre-yves samyn . However, the capabilities of text tables are limited and some of the Chart features may only work in Calc - or at least better.

Therefore I would like to hint that also a spreadsheet document can be linked into a text document as an OLE object, and if it contains a chart in the saved view, this chart will also show in the 'Writer' document. You can even edit the sheets - not the charts - in Writer and save the changes back to the source file. To edit the charts you need to open the spreadsheet document.

Some time ago I posted this answer to a related question in the German branch. If you cannot understand it there, the attached demo ask100415Demo_1.zip may help you. You need to expand both files contained in the zip into the same folder. To get the archive through the filter I appended the fake extension .odg. Simply remove it again. Open the .odt then.

(Editing to attach the demo announced in my recent comment to the fake answer by @Thomas:) @Tomas:)
Attachment demonstrating what I would suggest ignoring one of the OQ's requirements.

That's a great solution by @pierre-yves samyn . However, the capabilities of text tables are limited and some of the Chart features may only work in Calc - or at least better.

Therefore I would like to hint that also a spreadsheet document can be linked into a text document as an OLE object, and if it contains a chart in the saved view, this chart will also show in the 'Writer' document. You can even edit the sheets - not the charts - in Writer and save the changes back to the source file. To edit the charts you need to open the spreadsheet document.

Some time ago I posted this answer to a related question in the German branch. If you cannot understand it there, the attached demo ask100415Demo_1.zip may help you. You need to expand both files contained in the zip into the same folder. To get the archive through the filter I appended the fake extension .odg. Simply remove it again. Open the .odt then.

(Editing to attach the demo announced in my recent comment to the fake answer by @Tomas:)
Attachment demonstrating what I would suggest ignoring one of the OQ's requirements.

That's a great solution by @pierre-yves samyn . However, the capabilities of text tables are limited and some of the Chart features may only work in Calc - or at least better.

Therefore I would like to hint that also a spreadsheet document can be linked into a text document as an OLE object, and if it contains a chart in the saved view, this chart will also show in the 'Writer' document. You can even edit the sheets - not the charts - in Writer and save the changes back to the source file. To edit the charts you need to open the spreadsheet document.

Some time ago I posted this answer to a related question in the German branch. If you cannot understand it there, the attached demo ask100415Demo_1.zip may help you. You need to expand both files contained in the zip into the same folder. To get the archive through the filter I appended the fake extension .odg. Simply remove it again. Open the .odt then.

(Editing (Editing to attach the demo announced in my recent comment comment to the fake answer by @Tomas:)
Attachment demonstrating what I would suggest ignoring one of the OQ's requirements.