+ Reply to Thread
Results 1 to 2 of 2

How to rotate a radar chart by VBA in Excel 2003

  1. #1
    Registered User
    Join Date
    09-25-2009
    Location
    Taipei, Taiwan
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to rotate a radar chart by VBA in Excel 2003

    hi,all:
    Nice to meet you,guys!

    It's my first time to ask questions on the Internet.

    My problem is:

    I have a radar chart with 18 dimensions.
    By default, it will be divided from 0 degree, the north.
    But I need it to start from the position of 10 degree.

    Is there any way to rotate the axis of the radar chart?
    How to change the start point of the division?

    Thank you very much!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,976

    Re: How to rotate a radar chart by VBA in Excel 2003

    Unlike pie or donut you can not adjust angle of first point.

    In order to create the chart you will need to built it yourself using xy-scatter series and formula to calulate the position and angles of all the points and lines.

    Why do you need to tilt the chart?

    You could use a linked picture put the text as well as the axis and series would be rotated.
    Last edited by Andy Pope; 09-26-2009 at 06:54 AM.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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