Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Is it possible in calc to name a chart, not a chart's data range, as a named range? That is, is it possible to name a chart in its frame, not the range of cells that constitute the chart data source?

  1. A calc chart exists in a frame. The data incorporated into the chart can be defined as a named range.
  2. Is it possible to define the chart, not its data, as a named range?
  3. Is it possible then to insert this named range as a linked OLE object in an impress slide?

OR

Is it possible to select or define only an existing calc chart, not an entire calc sheet or a named range of cells, as a linkable OLE object?

Is it possible in calc to name a chart, not a chart's data range, as a named range? That is, is it possible to name a chart in its frame, not the range of cells that constitute the chart data source?

  1. A calc chart exists in a frame. The data incorporated into the chart can be defined as a named range.
  2. Is it possible to define the chart, not its data, as a named range?
  3. Is it possible then to insert this named range as a linked OLE object in an impress slide?

OR

Is it possible to select or define only an existing calc chart, not an entire calc sheet or a named range of cells, as a linkable OLE object?

Is Create an updatable link from withing Writer to a Calc Chart?

Because my original question seems to have been unclear to experienced users, I am once again asking it, but with revisions rendering it possible in calc to name a chart, not a chart's more clear. Thank you to the people who responded the first time.

Context: 1. I have a Writer document; 2. I have a Calc document (spreadsheet); 3. Within the Calc document is a chart; 4. The chart is created from data range, as a named range? That is, is it possible to name a chart in its frame, not the range of cells in that constitute the chart data source?

  1. A calc chart exists in a frame. same spreadsheet.

    Desired outcome: 1. Insert into the Writer document the chart in the Calc document; 2. The data incorporated into the chart can inserted chart is to possess two qualities: a. It is to be linked to the Calc document; b. Updates made in the Calc document appear also in the Writer document.

    Process outlined in LibreOffice user guides: 1. Perform these steps in Writer: Insert->Object->OLE object->Create from file->Link to file->Search->(select target file)->Open->OK

    Discussion: At no step in this process is a Calc chart defined as a named range.

  2. an entity. At no point is such an entity identified as an OLE candidate to be inserted, linked, and possessed of the quality of updatablility in a Writer document. The Writer Insert ->...->...->...-> OK process selects a file. At no point in the Writer Insert process are there instuctions or options allowing selection of an entity (the Calc chart) in the Calc document.

    Question: What do I need to do so that the Writer Insert -> link to file -> Search -> OK series of commands results in: 1. A Calc chart in a Writer document that a. Is it possible to define the chart, not its data, identifiable from within Writer using the Insert Object...OK command series as a named range?

  3. an OLE candidate; b. Is it possible then to selectable using the Writer Insert Object...OK command series; c. Is inked, once inserted in the Writer documenrt, to the source Calc document; and d. Can be updated in Calc so that the updates also appear in Writer.

    In other words, how do I insert this named range a defined Calc entity such as a linked OLE object in an impress slide?

OR

Is it possible to select or define only an existing calc chart, not an entire calc sheet or a named range of cells, chart into a Writer document as a linkable linked, updatable OLE object?

I hope the question is now clear.

Thanks for your insights and instructions.

Create an updatable link from withing Writer to a Calc Chart?

Because my original question seems to have been unclear to experienced users, I am once again asking it, but with revisions rendering it more clear. Thank you to the people who responded the first time.

Context: 1. I have a Writer document; 2. I have a Calc document (spreadsheet); 3. Within the Calc document is a chart; 4. The chart is created from data in that same spreadsheet.

Desired outcome: 1. Insert into the Writer document the chart in the Calc document; 2. The inserted chart is to possess two qualities: a. It is to be linked to the Calc document; b. Updates made in the Calc document appear also in the Writer document.

Process outlined in LibreOffice user guides: 1. Perform these steps in Writer: Insert->Object->OLE object->Create from file->Link to file->Search->(select target file)->Open->OK

Discussion: At no step in this process is a Calc chart defined as an entity. At no point is such an entity identified as an OLE candidate to be inserted, linked, and possessed of the quality of updatablility in a Writer document. The Writer Insert ->...->...->...-> OK process selects a file. At no point in the Writer Insert process are there instuctions or options allowing selection of an entity (the Calc chart) in the Calc document.

Question: What do I need to do so that the Writer Insert -> link to file -> Search -> OK series of commands results in: 1. A Calc chart in a Writer document that a. Is identifiable from within Writer using the Insert Object...OK command series as an OLE candidate; b. Is selectable using the Writer Insert Object...OK command series; c. Is inked, once inserted in the Writer documenrt, to the source Calc document; and d. Can be updated in Calc so that the updates also appear in Writer.

In other words, how do I insert a defined Calc entity such as a chart into a Writer document as a linked, updatable OLE object?

I hope the question is now clear.

Thanks for your insights and instructions.