+ Reply to Thread
Results 1 to 2 of 2

Format Data Labels via VBA

  1. #1
    Registered User
    Join Date
    04-26-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    18

    Post Format Data Labels via VBA

    Hi Guys,

    Help please, I am trying to format the data labels that appear on the piechart through vba. As the graph is autocreated via a macro I do not want to have to manually format the graph. I need to change the colour and make bold the data labels.

    The current code is as follows.
    Please Login or Register  to view this content.
    all and any help will as always be much appreciated.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Format Data Labels via VBA

    Please Login or Register  to view this content.
    Does you chart really have +100 slices? and why the additional columns selected for data source?
    Cheers
    Andy
    www.andypope.info

+ 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. Format Chart Data Labels Alignment
    By MissaLissa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2013, 04:11 AM
  2. macro to format data Labels
    By subhs82 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-23-2011, 03:50 PM
  3. Macro to format data points and labels
    By ridingbio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2011, 02:07 PM
  4. How do I format the data labels in my stacked bar graph?
    By ocjred in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-02-2006, 11:05 AM
  5. data labels change format
    By john mcmichael in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-16-2006, 12:20 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