+ Reply to Thread
Results 1 to 4 of 4

Apply border to data label

  1. #1
    Forum Contributor
    Join Date
    08-05-2009
    Location
    Salt Lake City, UT
    MS-Off Ver
    Office 365
    Posts
    145

    Apply border to data label

    I am trying to apply a border to a data label for a single point, but I cannot find how it's done. Here's where I am

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: Apply border to data label

    Hello Atom,

    Please attach a sample workbook.

    Make sure there is just enough data to demonstrate your need.

    Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Contributor
    Join Date
    08-05-2009
    Location
    Salt Lake City, UT
    MS-Off Ver
    Office 365
    Posts
    145

    Re: Apply border to data label

    I guess I don't understand the request. The code I posted runs just fine. I simply cannot find or figure out the vba syntax for adding a border to a data label object.

  4. #4
    Forum Contributor
    Join Date
    08-05-2009
    Location
    Salt Lake City, UT
    MS-Off Ver
    Office 365
    Posts
    145

    Re: Apply border to data label

    This is what I was looking for:
    .Points(Range("AD99").Value).DataLabel.Border.LineStyle = xlContinuous

+ 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] Apply Border to Main Area
    By delaing in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-05-2016, 06:15 PM
  2. Border line thickness on image or label
    By brewsi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2015, 09:44 AM
  3. [SOLVED] Conditional Data Label border
    By Jabba69 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 07-21-2014, 09:44 AM
  4. Apply Border based on change in cell value?
    By efeb in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-11-2009, 04:41 PM
  5. Change label border color at runtime
    By timspier in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2006, 02:53 AM
  6. [SOLVED] Apply Border
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-28-2005, 08:05 PM
  7. [SOLVED] Apply Border based on last Day of Month
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2005, 03:05 PM

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