+ Reply to Thread
Results 1 to 3 of 3

Radar Graph change parameters with macro

  1. #1
    Registered User
    Join Date
    11-01-2012
    Location
    Cyprus
    MS-Off Ver
    Excel 2013
    Posts
    48

    Radar Graph change parameters with macro

    Hi all,
    I am looking for the function parameter to use in order to change:
    a. The category labels font size and color.
    b. The grid lines internally of the graph. I have managed to change the ones that goes from the center of the graph to the points of category labels using .HasMajorGridlines but cannot find the property to use to change the others also.

    Any help appreciated.
    Thank you.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,694

    Re: Radar Graph change parameters with macro

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-01-2012
    Location
    Cyprus
    MS-Off Ver
    Excel 2013
    Posts
    48

    Re: Radar Graph change parameters with macro

    Thank you for the response. My code is as follows:
    Please Login or Register  to view this content.
    When i enter your solution it does not identify the object. The only piece i need to complete my chart is to change the size and color of my category labels and change the color and transparency of my grid lines. How can i adjust your solution to my code? Thank you again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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