Results 1 to 2 of 2

Thread: VBA - remove bar chart outlines

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2017
    Posts
    1

    Post VBA - remove bar chart outlines

    Hi all,

    for all my excel charts, I am looking to set the following rules:

    Format chart area > border colour > No fill

    My issue is that I have charts that have a set 'solid line' around my bar charts. I am looking for a VBA script that will help remove this border on all my charts

    your help is much appreciated.

  2. #2
    PowerPoster
    Join Date
    Oct 2008
    Location
    Midwest Region, United States
    Posts
    3,574

    Re: VBA - remove bar chart outlines

    When I record a macro and remove the border, it generates this:

    Code:
    ActiveSheet.Shapes("Chart 1").Line.Visible = msoFalse


    If you're talking about multiple charts in a book, you'd loop through the chart objects and do something like to each.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width