Conform several graphs/charts copied into MS Word to same size and format

Hello, I have several graphs/charts that were created in MS Excel that I've copied into a MS Word document and now need to conform all of the graphs/charts so that they are the same size (height/width) and format. Is anyone aware of a process or macro or utility that could do that for me? Thanks in advance...
jaguar5554Business AnalystAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
FlysterConnect With a Mentor Commented:
Try this macro. Just change the height and width values to meet your needs.
Sub FormatShapes()
Dim i, x As Integer

i = ActiveDocument.InlineShapes.Count
    For x = 1 To i
        With ActiveDocument
            .InlineShapes(x).Height = 115.2
            .InlineShapes(x).Width = 220.3
        End With
    Next x
End Sub

Open in new window

Flyster
0
 
jaguar5554Business AnalystAuthor Commented:
That is amazing! Thank you so much!
0
 
FlysterCommented:
Happy to be of service!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.