+ Reply to Thread
Results 1 to 3 of 3

fix the position of a text box in an x-y graph

  1. #1
    Registered User
    Join Date
    11-23-2020
    Location
    Amstelveen, Netherlands
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    6

    fix the position of a text box in an x-y graph

    Hello,
    I have an xy-graph in which I put a dynamic text box (I selected the graph, went to Format, insert shapes and selected text box).
    It would be great when I could fix the position of the textbox (for instance the left top corner) to a fixed x-y coordinate in the graph.
    Tips are very welcome!
    Best regards, Marcel

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: fix the position of a text box in an x-y graph

    Rather than use a text box, I would use a "dummy" point and its data label.
    1) Enter your desired x and y coordinates in a convenient pair of cells.
    2) Add this pair of points as a new series to the XY scatter chart.
    3) Add the data label to this point/series, then edit/format the data label to display the desired text.

    https://support.microsoft.com/en-us/...2-f467c9f4eb2d
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    11-23-2020
    Location
    Amstelveen, Netherlands
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    6

    Re: fix the position of a text box in an x-y graph

    done (!!!)

    as they say, try to think "outside the box", eh?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Position of graph affects performance
    By esskaykay in forum Excel General
    Replies: 1
    Last Post: 09-28-2020, 01:16 PM
  2. Paste graph from excel to a specific position in powerpoint slide
    By yattick in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-28-2017, 11:26 AM
  3. [SOLVED] Specify position on graph rather than middles/lefts/rights
    By michelle 1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-09-2015, 04:16 PM
  4. Replies: 2
    Last Post: 09-04-2015, 12:39 AM
  5. Replies: 0
    Last Post: 10-03-2014, 07:51 AM
  6. Authomatic extend x axis by one position in a dynamic graph
    By kevinkits in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-19-2013, 03:01 AM
  7. Replies: 4
    Last Post: 12-20-2012, 04:33 AM

Tags for this Thread

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