+ Reply to Thread
Results 1 to 4 of 4

Help with my VBA Code - Modify Chart Border/Fill for Dashboard

  1. #1
    Registered User
    Join Date
    05-16-2014
    MS-Off Ver
    Excel 2003
    Posts
    6

    Help with my VBA Code - Modify Chart Border/Fill for Dashboard

    Hello,

    I am currently working on a business dashboard that has 3 main charts that depict business unit performance.

    The charts update based on the business score and are color rated (Score>90% is Green, Score<90% and >75% = Yellow, Score<75% = Red).

    In addition to updating the color I would also like the chart to have no fill and no border. Can anyone help me add this to the current code?

    here is the current code:

    Please Login or Register  to view this content.

    Any and all help is much appreciated.

    Regards,

    Joel

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Help with my VBA Code - Modify Chart Border/Fill for Dashboard

    you can use macro recorder to find the correct code
    If solved remember to mark Thread as solved

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

    Re: Help with my VBA Code - Modify Chart Border/Fill for Dashboard

    The vba code would suggest excel 2007 or newer which means it's possible the code would not be recorded.
    Here's what I get in xl2007 when removing border and fill.

    Please Login or Register  to view this content.
    This is the code required.
    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    05-16-2014
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Help with my VBA Code - Modify Chart Border/Fill for Dashboard

    Hi Andy,

    Thanks so much.

    I had previously tried to record the macro but, as I am new to vba, couldn't quite figure out how to incorporate it into my current code.

    The code I recorded in excel 2010 looked like this.
    Please Login or Register  to view this content.
    The code you have provided works great.

    Thanks again!

+ 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. Replies: 12
    Last Post: 02-07-2014, 04:00 PM
  2. Remove Chart Area Border - Where in Code is it Added?
    By Janc in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-13-2011, 06:40 AM
  3. MDB Pivot table to dashboard chart
    By GreenatExcel in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-08-2007, 04:27 PM
  4. [SOLVED] For complex dashboard: What type of chart to use?
    By Bev in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-22-2006, 07:55 PM
  5. [SOLVED] code to fill in missing border lines
    By Jack Sons in forum Excel General
    Replies: 3
    Last Post: 11-03-2005, 06:10 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