+ Reply to Thread
Results 1 to 3 of 3

Getting the Displayed Name of a Chart Point.

  1. #1
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Getting the Displayed Name of a Chart Point.

    The following tells me that the name of the point is "S1P1" however the label on the chart says "Widget A." What do I have to use instead of .Name to get "Widget A?" Obviously this code is the start of something bigger.
    Please Login or Register  to view this content.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

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

    Re: Getting the Displayed Name of a Chart Point.

    If I understand what you are trying to do, don't we need to go through the "datalabel" object to get the text of a data label? Or are you talking about a series that does not have data labels?
    https://msdn.microsoft.com/en-us/lib.../ff838393.aspx
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: Getting the Displayed Name of a Chart Point.

    I knew that as soon as I posted the question, I'd find the answer. Here it is:

    http://answers.microsoft.com/en-us/m...acf0e70?auth=1

+ 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. Point displayed at origin (0,0) that isn't there!
    By Dr PE in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 05-14-2024, 07:18 PM
  2. Display small chart on mouseover of another chart's data point
    By OnRope in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-17-2013, 09:07 PM
  3. Replies: 2
    Last Post: 06-27-2011, 10:47 PM
  4. exclude zero value from being displayed in chart
    By bocean in forum Excel General
    Replies: 2
    Last Post: 03-19-2010, 10:15 AM
  5. Power Point Chart linked to Excel Chart
    By pr4t3ek in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 09-24-2009, 11:33 AM
  6. [SOLVED] Chart Series Not displayed
    By Barb Reinhardt in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-05-2006, 06:10 AM
  7. Replies: 0
    Last Post: 03-21-2005, 05:06 PM
  8. Need for categories to be displayed in chart
    By Ted Mifflin in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-19-2005, 01:06 AM

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