+ Reply to Thread
Results 1 to 2 of 2

Pinning a Callout to its Data Point

  1. #1
    Registered User
    Join Date
    10-03-2012
    Location
    St. Louis, Missouri
    MS-Off Ver
    MS 2013, 64Bit, 8 Cores, 20GB
    Posts
    18

    Pinning a Callout to its Data Point

    I'm using a script to generate a graph, and add callouts to that graph...
    Is there a way to anchor each callout to its respective cell within the worksheet range instead of the callout being associated with a point index fixed to the graph?

    For example, the image below shows the graph with the desired callouts for a 128k point dataset; there are 131 callouts.
    Each callout is labeled as [dataset index, value at that index].

    all callouts.PNG

    If I change the charts data range from 1-128,000 points to the first 2000 points (range A1:A2000) I get an accurate result (see below).

    first2000points.PNG

    But, if I change the graph to the second set of 2000 points (range A2000:A4000) then I get datalabels associated with the points/positions within the graphs data range, and not associated with the dataset index (see below).
    In other words, changing the graph's data range doesn't move the callout index (1st value in the callout) accordingly.

    wrongdata.PNG


    So, what I'm asking, is it possible to associate a datalabel with a cell in a range (the original full data range) instead of it being associated with a .SeriesCollection position/index that changes when the graph data range changes?



    Thanks in advance,
    Last edited by gth826a; 07-20-2017 at 01:26 PM.

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

    Re: Pinning a Callout to its Data Point

    Short but useless answer: Yes, I am confident that such a thing is possible. I am generally confident that most things are possible with enough time, effort, and ingenuity.

    Beyond that, I'm not sure I have any good recommendations. From your other threads, everything you are doing here and in your other questions is all part of a larger macro that is creating and formatting the chart. I think it will help us help you if we can see this request in the context of the broader macro and spreadsheet project, which we just cannot see from a few pictures/screenshots. At this point, I would recommend that you upload a small spreadsheet that is representative of your real spreadsheets. Explain this request within that context, so we can better see how you are trying to use this feature.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Pinning a worksheet to the taskbar
    By Trebor777 in forum Excel General
    Replies: 1
    Last Post: 08-30-2016, 01:00 PM
  2. Pinning Webpage to Taskbar (OS Win7)
    By GautamAXA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-09-2015, 07:52 AM
  3. Replies: 2
    Last Post: 06-27-2011, 10:47 PM
  4. pinning excel
    By novice2430 in forum Excel General
    Replies: 0
    Last Post: 08-25-2008, 11:48 AM
  5. Pin a callout data point
    By Dave in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-01-2006, 08:50 PM
  6. Pin a Callout
    By Dave in forum Excel General
    Replies: 1
    Last Post: 03-31-2006, 08:30 AM
  7. [SOLVED] Circular CallOut
    By Nesarkar in forum Excel General
    Replies: 1
    Last Post: 03-30-2005, 09:06 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