+ Reply to Thread
Results 1 to 5 of 5

Pictures with Data from Exel-Cells

Hybrid View

  1. #1
    xirx
    Guest

    Pictures with Data from Exel-Cells

    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?

  2. #2
    aidey
    Guest

    Re: Pictures with Data from Exel-Cells

    >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


  3. #3
    xirx
    Guest

    Re: Pictures with Data from Exel-Cells

    aidey wrote:
    >>From Excel help: [...]


    Blurp. Didn't found that. Thanks! That's exactly
    what I was looking for.

  4. #4
    xirx
    Guest

    Re: Pictures with Data from Exel-Cells

    Another Question:

    Is it possible to use excel cell values for attributes
    (such as color, line width, etc) of an autoshape?

    aidey wrote:
    >>From Excel help:

    >
    > Link an AutoShape or text box to a worksheet cell


    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

  5. #5
    xirx
    Guest

    Re: Pictures with Data from Exel-Cells

    Another Question:

    Is it possible to use excel cell values for attributes
    (such as color, line width, etc) of an autoshape?

    aidey wrote:
    >>From Excel help:

    >
    > Link an AutoShape or text box to a worksheet cell


    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1