+ Reply to Thread
Results 1 to 10 of 10

Macro for bolding text in chart.

  1. #1
    Registered User
    Join Date
    02-26-2012
    Location
    Riga
    MS-Off Ver
    Excel 2007
    Posts
    13

    Macro for bolding text in chart.

    Hello!

    Basically what i want macro to do is to bold the text which is in 2nd row in value labels, in selected chart.
    1.jpg ---->>>>> 2.jpg

    And I have no idea how to do it.
    Can anyone please help?

  2. #2
    Registered User
    Join Date
    02-26-2012
    Location
    Riga
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Macro for bolding text in chart.

    bump for answers

  3. #3
    Valued Forum Contributor
    Join Date
    04-30-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    547

    Re: Macro for bolding text in chart.

    You may get more response if you post the file with the chart instead of an image.

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Macro for bolding text in chart.

    be easier if you posted a workbook instead of pictures but I reckon something like this oughta do it
    Please Login or Register  to view this content.
    btw a bar chart would be more legible and you wouldn't need to worry about formatting the labels.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  5. #5
    Registered User
    Join Date
    02-26-2012
    Location
    Riga
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Macro for bolding text in chart.

    grafiks.xlsm

    I tried the previous macro but I'm having problems as it doesn't bold all the labels correctly.

    My collegue said that the problem starts with 3rd label. It bolds first 3 labels correctly and then it goes back and messes up first 2 labels.
    Last edited by Naidonis; 06-04-2012 at 04:12 AM.

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Macro for bolding text in chart.

    it may be an issue with the special characters in the text. I'll have to think about that and get back to you

  7. #7
    Registered User
    Join Date
    02-26-2012
    Location
    Riga
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Macro for bolding text in chart.

    thank you a lot.

  8. #8
    Registered User
    Join Date
    02-26-2012
    Location
    Riga
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Macro for bolding text in chart.

    I don't think that it's the problem with special characters cause changing labels to standart english symbols didn't help.

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

    Re: Macro for bolding text in chart.

    The code works fine in xl2003.
    I think this is a bug in charting Object model. It may work for a data label or 2 but then things stop working probably.
    Cheers
    Andy
    www.andypope.info

  10. #10
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Macro for bolding text in chart.

    and it worked in my initial tests in 2011.

+ 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