Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Change font size of axis labels (etc.) in several charts created in Word 2007 (using VBA)

Posted on 2010-11-22
7
Medium Priority
?
1,278 Views
Last Modified: 2012-05-10
Dear Experts:

I got dozens of charts created directly in a 2007 document.

I'd like to change the font size of the diagram title, axes and axis labels in one go for all charts.

How is this achieved. I attached a sample file for your convenience.

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
0
Comment
Question by:AndreasHermle
  • 3
  • 3
7 Comments
 
LVL 5

Expert Comment

by:Erk333
ID: 34187901
You can right-click directly on the labels to get the floating text format bar.
0
 
LVL 5

Expert Comment

by:Erk333
ID: 34187917
ahhh....i see your looking for a global chart style edit.....brb : )
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 34188048
Hi Andreas. I think that you have forgotten to attach the document.
0
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

 
LVL 5

Expert Comment

by:Erk333
ID: 34188569
the functionality changed somewhat in 2007+ to 'templates' from user-defined chart types.  You can save a desired chart format as a template and apply it to other charts (albeit 1 at a time) but i assume your looking to retain the type (bar, line, pie etc...) and only change some elements like font or color. it would seem a global style or type change is unavailable with out creating some custom VBA in excel and that would seem to be more work than the task requires and it does not really leave room for a style 'change of mind' on the fly.
yes....applying a style element(s) to multiple fields on the fly would be nice functionality to have in the future
0
 

Author Comment

by:AndreasHermle
ID: 34188718
Dear all,

first of all, thank you very much for your swift help. I will take a look at Erk333's answer later today.

In the meantime I will attach the file I have forgotten to add. Graham, thank you for bringing this to my attention.

Regards, Andreas Charts-Created-in-Word-2007.docx
0
 

Accepted Solution

by:
AndreasHermle earned 0 total points
ID: 34614758
Dear all:

found some source with the solution to the problem.
Sub ModifyWordCharts()
    Dim ilsh As InlineShape
    Dim i As Integer
   
    For Each ilsh In ActiveDocument.InlineShapes
        If ilsh.Type = wdInlineShapeChart Then
            For i = 1 To 2
                With ilsh.chart.Axes(i)
                    If .Type = 1 Then 'Category Axis
                        .TickLabels.Font.Size = 7.5
                    Else 'Values Axis
                        .TickLabels.Font.Size = 9
                    End If
                    .TickLabels.Font.Name = "Arial"
                    .HasMajorGridlines = False
                    .HasMinorGridlines = False
                End With
            Next i
        End If
    Next ilsh
End Sub

Open in new window

0
 

Author Closing Comment

by:AndreasHermle
ID: 34824259
I found some source on the internet that exactly matched my macro requirements.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you ever need to create a 20 page Word document for some testing purpose? Are you tired of copying & pasting old boring "lorem ipsum" text over and over again, increasing font size and line space in order to make the document 20+ pages long? Look…
I would like to show you some basics you can do with Mailings in MS Word. It´s quite handy feature you can use for creating envelopes, labels, personalized letters etc. First question could be what is this feature good for? Mailing can really he…
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
Suggested Courses
Course of the Month7 days, 6 hours left to enroll

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question