+ Reply to Thread
Results 1 to 4 of 4

Labels colour in xlBarStacked Chart

  1. #1
    Forum Contributor
    Join Date
    04-22-2014
    Location
    Turrialba, Costa Rica
    MS-Off Ver
    Excel 2010
    Posts
    108

    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,111

    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
    Forum Contributor
    Join Date
    04-22-2014
    Location
    Turrialba, Costa Rica
    MS-Off Ver
    Excel 2010
    Posts
    108

    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,111

    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)

Similar Threads

  1. X Y Scatter Chart, with Labels & colour coded markers
    By Stephanieaw in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-25-2018, 08:54 AM
  2. VBA to colour data labels same as line colour - dynamic chart
    By Jabba69 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-06-2014, 10:59 AM
  3. Creating a xlBarStacked chart from arrays on with VBA
    By dherrero in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2014, 08:40 AM
  4. Change chart/pivot table numeric labels to associated text labels
    By petschek in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-07-2014, 05:32 PM
  5. Changing colour of bar chart, whilst keeping the labels on x-axis
    By trueng in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-16-2013, 06:05 AM
  6. to change the colour of the data labels in a chart
    By saji in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2013, 05:49 AM
  7. Colour change column chart based on cell colour
    By Alice21 in forum Excel General
    Replies: 11
    Last Post: 04-05-2011, 10:10 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