-
May 8th, 2017, 08:52 AM
#1
Thread Starter
New Member
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.
-
May 8th, 2017, 12:44 PM
#2
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|