Ask Your Question

Need to insert cell data into a text box [closed]

asked 2018-11-20 04:07:27 +0200

Todd2 gravatar image

Hi All, Calc

I have a graph I need to place a text box into and into that text box I need to insert the value from a cell.

Google gives me

Problem. Step 4

Open the Context menu on the TextBox, and Select "Control..." menu (4th option, with spanner icon)

I right click on the test box, no such animal. No spanner icon either

How do I put cell data in a text box on a graph?

Many thanks, -T

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2019-04-17 22:29:29.213495


There are two types of "text box." #1 is a floating frame where you can insert formatted text, paragraphs, images, and so on - found under "Insert -> Text Box". #2 is a form control where you can input/output text data. #1 will not have the "control" option when you right-click on it. #2 does have the option. Each "text box" has very different purposes. I don't think you can insert a chart into the #2 (maybe not #1 either, not sure). #2 text box can have text inserted via macros from cell(s).

PhLo gravatar imagePhLo ( 2018-11-20 06:46:19 +0200 )edit

Since charts are already floating objects that you can move around in Calc, maybe there's not a need to put it into a "text box"? If you right-click on the chart and choose Anchor -> To Page, you can drag it around freely.

PhLo gravatar imagePhLo ( 2018-11-20 06:48:27 +0200 )edit

I need to write dynamic information on the chart

Todd2 gravatar imageTodd2 ( 2018-11-20 08:50:30 +0200 )edit

cool, gotcha

PhLo gravatar imagePhLo ( 2018-11-20 08:58:58 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-11-20 07:00:09 +0200

JohnSUN gravatar image

updated 2018-11-20 10:13:35 +0200

Yes, now it looks a little different - in six years the location of the elements and their icons have changed, this is somewhat confusing. In the instruction to which you refer, these interface elements are mentioned (the numbers indicate the instruction points in which the element is named)

New controls.png

The complete process of inserting fields into the diagram looks like this:

Set Text Fields To Chart.gif

edit flag offensive delete link more


I guess at this point I need to say what I am trying to do. I have a graph that takes its values from a spreadsheet to its left. On the sheet to the left are two cells with the date and the number of the data set. I need both of these to print out in the upper left of the graph

Todd2 gravatar imageTodd2 ( 2018-11-20 08:23:56 +0200 )edit

Yes, I understand your difficulty. I edited my answer

JohnSUN gravatar imageJohnSUN ( 2018-11-20 10:14:53 +0200 )edit

Wow! Awesome! Thank you!

Any way to do "some comment B2"

Todd2 gravatar imageTodd2 ( 2018-11-20 10:17:03 +0200 )edit

Sorry, I did not understand. Are you interested in what B2 is? This is the address of the cell in which the "data number" is located. Or did you mean something else?

JohnSUN gravatar imageJohnSUN ( 2018-11-20 10:20:51 +0200 )edit

Wow! Awesome. Thank you!

Should I be able to draw a text box inside the upper left of the chart (where no data will ever appear)?

Todd2 gravatar imageTodd2 ( 2018-11-20 10:45:40 +0200 )edit

I want to put " blah blah blah <data from="" b2="">" into the text box. I can always to two boxes

Todd2 gravatar imageTodd2 ( 2018-11-20 10:46:50 +0200 )edit

I had the sheet locked and forgot to unlock it.

Todd2 gravatar imageTodd2 ( 2018-11-20 11:30:51 +0200 )edit

answered 2019-04-17 17:19:42 +0200

IEales gravatar image

The test box is not on the chart, it is just over it.

It DOES NOT export.

LO need to have dynamic fields and titles on charts!!!

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-11-20 04:07:27 +0200

Seen: 1,056 times

Last updated: Apr 17 '19