Pictures with Data from Exel-Cells

  • Thread starter Thread starter xirx
  • Start date Start date
X

xirx

Hi!

Is there any way to have a picture in Excel that
has labels - text or numbers - from Excel cells?

Excel has the option to insert "Diagrams". In
this diagrams, you create objects such as boxes,
circles, lines, etc. And you can add Text-Boxes.
I'd like to write "A1" in such a text box, and
would like to the the content of cell A1 in that
Text cell.

Is this (or something like this) possible?

Any pointers?
 
From Excel help:

Link an AutoShape or text box to a worksheet cell

1 Click the AutoShape or text box you want to link.
2 In the formula bar, type an equal sign (=).
3 Click the worksheet cell that contains the data or text you want to
link to.

You can also type the reference to the worksheet cell. Include the
sheet name, followed by an exclamation point, for example:

Sheet1!F2

4 Press ENTER.

Aidey
 
Another Question:

Is it possible to use excel cell values for attributes
(such as color, line width, etc) of an autoshape?
Link an AutoShape or text box to a worksheet cell
Click to expand...

Hm, I am still unable to find that in the Exel help.
Tried to paste this sentence to the Answer Wizzard
and also searched the index. There is nothing about
it in "my" help...

xirx
 
Another Question:

Is it possible to use excel cell values for attributes
(such as color, line width, etc) of an autoshape?
Link an AutoShape or text box to a worksheet cell
Click to expand...

Hm, I am still unable to find that in the Exel help.
Tried to paste this sentence to the Answer Wizzard
and also searched the index. There is nothing about
it in "my" help...

xirx
 
Back
Top