+ Reply to Thread
Results 1 to 2 of 2

Overlaying Cell "Viewport" Over Chart

  1. #1
    Registered User
    Join Date
    01-06-2016
    Location
    Virginia, USA
    MS-Off Ver
    2013
    Posts
    2

    Overlaying Cell "Viewport" Over Chart

    Hey everyone,

    So I have some calculation in a box of 6 cells or so, and I would like to essentially display those calculations on top of a graph. I know you can do a text box and make the text box equal to each individual cell. But I'm curious if there is a way to essentially make a "viewport" (similar to AutoCAD for those familiar) where the calculations would be displayed over the chart as if there was a permanent camera on them.

    Hopefully this is clear, but if not please let me know and I'll provide some clarification. Thanks in advance for all of your help everyone!

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Overlaying Cell "Viewport" Over Chart

    You can use the Camera tool to create an object that updates when the data changes. The effect is as follows:
    Overlay.JPG
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. [SOLVED] VBA help needed to remove all "/" then replace with "-" from cell "B3"and "B5"
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2014, 02:11 PM
  2. [SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  3. Replies: 2
    Last Post: 06-25-2013, 12:43 PM
  4. [SOLVED] Data validation: allow entry into a cell if other three cells have "X", "Y" and "Z"?
    By RogerRangeRover in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2013, 04:49 AM
  5. [SOLVED] Problem creating Line Chart from columns "date" and "money"
    By brosef in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-05-2012, 09:01 AM
  6. Replies: 0
    Last Post: 09-17-2012, 01:17 PM
  7. Replies: 0
    Last Post: 06-08-2010, 03:27 PM
  8. Replies: 4
    Last Post: 02-03-2008, 05:11 PM

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