+ Reply to Thread
Results 1 to 2 of 2

How to change axis font size for a bar chart

Hybrid View

  1. #1
    Registered User
    Join Date
    08-05-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    Exclamation How to change axis font size for a bar chart

    Hi, I have a simple bar chart, I need to change the font size of the axis values

    the following is what i have and it doesnt work

    ActiveChart.ChartArea.Select
    ActiveChart.Axes(xlValue).Select
    With Selection.Format.TextFrame2.TextRange.Font
    .BaselineOffset = 0
    .Size = 11
    End With

    error message: Method 'TextFrame2' of object 'ChartFormat' Failed

    anything would be appreciated Thanks !

  2. #2
    Registered User
    Join Date
    08-05-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    Re: How to change axis font size for a bar chart

    nvm figured it out on my own

+ 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. [SOLVED] How to change the Font Properties of Chart Primary/Secondary X-Y Axis Title using VBA ?
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-09-2013, 09:49 AM
  2. [SOLVED] Change default font and font size on COMMENTS in cells
    By Thistledown in forum Excel General
    Replies: 4
    Last Post: 11-23-2012, 09:26 AM
  3. VBA change the chart font size
    By Apple Ling in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-28-2012, 02:51 AM
  4. Infuriating VB Excel chart issue - how to change y axis font color
    By Ace of Clubs in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-07-2009, 01:22 AM

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