+ 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
    Aberdeen
    MS-Off Ver
    Excel 2016
    Posts
    60

    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
    O365
    Posts
    20,419

    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
    Aberdeen
    MS-Off Ver
    Excel 2016
    Posts
    60

    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)

Similar Threads

  1. Polar/ radar/ graph made with goal times like attachment
    By jono121ukk in forum Excel Charting & Pivots
    Replies: 16
    Last Post: 03-27-2019, 03:38 PM
  2. Standard colors in Radar Graph
    By hond in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-08-2016, 07:37 AM
  3. Change Pivot radar chart with macro
    By Horatius in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-30-2014, 06:12 AM
  4. Macro to graph based on parameters
    By Kniemann in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-14-2014, 08:56 AM
  5. Radar graph questions
    By gamtnman44 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-18-2013, 03:53 AM
  6. [SOLVED] radar graph
    By Russell-stanely in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-14-2005, 12:15 PM
  7. Replies: 2
    Last Post: 10-17-2005, 11:05 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