+ Reply to Thread
Results 1 to 4 of 4

Labels colour in xlBarStacked Chart

  1. #1
    Registered User
    Join Date
    04-22-2014
    Location
    Turrialba, Costa Rica
    MS-Off Ver
    Excel 2010
    Posts
    99

    Labels colour in xlBarStacked Chart

    Hello.
    In MS Access this code displays in Excel BarStacked labels black in colour.
    Please Login or Register  to view this content.
    How can I change font colour labels (bold and size=12) to red?

    I still donīt understand how to work with charts and its components.

    Any help (links/tutorials) code examples are welcome.

    Cheers

  2. #2
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,083

    Re: Labels colour in xlBarStacked Chart

    G'day,

    The following links may help

    https://docs.microsoft.com/en-us/off...label.fontbold

    https://docs.microsoft.com/en-us/off...label.fontsize
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  3. #3
    Registered User
    Join Date
    04-22-2014
    Location
    Turrialba, Costa Rica
    MS-Off Ver
    Excel 2010
    Posts
    99

    Re: Labels colour in xlBarStacked Chart

    ratcat. I really appreciate your reply.
    After my post here on 11-03-2018, I started to try some VBA code instructions.
    I decided to add
    Please Login or Register  to view this content.
    that generated the third bar.
    In the third bars, I inserted labels and then
    Please Login or Register  to view this content.
    Now my
    Please Login or Register  to view this content.
    shows bars and labels with values that I need.

    Nevertheless, my problem is that sometimes when I run the code for the second time VBA displays the message:
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    When the error occurs is always here:
    Set a = Range ("A2: A" & Rows.Count)

    I already revised the following links.
    http://support.microsoft.com/default.aspx?kbid=178510
    http://www.tek-tips.com/viewthread.cfm?qid=756598

    To this date, I have not been able to use the links help to correct the Error.

    Any help is welcome.

  4. #4
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,083

    Re: Labels colour in xlBarStacked Chart

    G'day gipsyfkls14,

    To keep inline with forum rules if your original post issue (according to title of the thread) is completed please mark it "Solved". Then start a new thread with the issue you have presented in post #3 of this thread. This will have many benefits to you and future users of this forum.

    Please note that I have a suggestion for your rows error but I myself still have the learners driver plate on for when giving advice on vba.

    If you do need any help and you do start a new thread feel free to PM me the url in case I overlook the thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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