+ Reply to Thread
Results 1 to 3 of 3

Altering a Callout in a Graph/Chart

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

    Altering a Callout in a Graph/Chart

    I have a script that takes in a range, as Selection, and at the end of the algo, generates a line graph of that data.
    I want to add Callouts on the graph for specific data points...
    I've been able to create the Callouts (partial code below), but I want the Callouts to show both the x & y values... currently it only shows the y value.


    Please Login or Register  to view this content.

    Here is a picture of the output:
    output.PNG

    But, I want it to look like this:
    Capture.PNG




    SOLUTION:

    Please Login or Register  to view this content.


    ALTERNATE SOLUTION:

    Please Login or Register  to view this content.
    Last edited by gth826a; 07-21-2017 at 12:22 PM.

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

    Re: Altering a Callout in a Graph/Chart

    [post deleted]
    Last edited by gth826a; 07-21-2017 at 12:21 PM.

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,343

    Re: Altering a Callout in a Graph/Chart

    This is way beyond my area of expertise, but I am a little surprised that you did not simply use the showcategoryname and showvalue properties of the datalabel object: https://msdn.microsoft.com/VBA/Excel...l-object-excel
    As I indicated in the other thread, we might be able to make better recommendations if you will provide a more complete example that we can look at.
    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. Need help altering Pivot chart
    By musicgirl in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-05-2016, 11:48 AM
  2. [SOLVED] Altering chart color based on data
    By DrStrangepork in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-20-2013, 12:32 PM
  3. Pareto Chart without altering data
    By perksaus in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-10-2013, 06:54 PM
  4. Excel 2007 : Excel bar graph altering x axis dates
    By MCAexcel in forum Excel General
    Replies: 1
    Last Post: 07-26-2011, 03:33 AM
  5. Altering x-coordinates on graph
    By hockey_addict in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 12-09-2008, 01:11 PM
  6. Altering the axis on a chart
    By slinger1010 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-22-2007, 04:32 PM
  7. Altering the range that is plotted by a chart via VBA
    By Peter Rooney in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-21-2005, 06:05 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