+ Reply to Thread
Results 1 to 6 of 6

Polar curve plotted in polar chart

  1. #1
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Polar curve plotted in polar chart

    Hello,
    I have problem how to draw a curve onto a polar chart that is based on degree
    and its values.

    Also after the curve is plotted, then I like to extract the curve equation.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Polar curve plotted in polar chart

    Andy Pope has a polar plot add-in at http://www.andypope.info/charts/polarplot3.htm. I've not used it, but expect it's great.

    You're not going to be able to regress that with a polynomial. Maybe Fourier regression -- it has the shape of a pulse (after you make it symmetric).
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Polar curve plotted in polar chart

    There's a Fourier expansion of your function at https://app.box.com/s/ereqysafe9cshbpuu5fg

  4. #4
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Re: Polar curve plotted in polar chart

    Hi shg,
    I download this add-in before, I have not spend a lot time to try.
    But I am looking for VBA to draw the curve and polar chart, even
    if it can also create the text for the angles.

    The table will be come from external text file that will be inserted
    the specified cell to automate the report only using few keys.

    Maybe the point from table in degree and value (consider
    it is the length from 0,0) may need to convert to X,Y so that
    it can plot the curve. Same true for the polar chart.

    Is there an equation to draw the polar chart, 1/4 circle, text in degree
    placed on the chart liked the sample?

    Thanks

  5. #5
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Re: Polar curve plotted in polar chart

    I will try this. thanks

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Polar curve plotted in polar chart

    You're welcome.

+ 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. Replies: 1
    Last Post: 06-20-2013, 01:14 PM
  2. polar plots (add-in)
    By dharshanie in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-01-2006, 08:00 AM
  3. Polar Plot
    By itemanise in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-17-2006, 12:00 AM
  4. Polar chart... how
    By Ralph2 in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 12-15-2005, 11:00 AM
  5. polar response
    By DaveT in forum Excel General
    Replies: 1
    Last Post: 11-03-2005, 11:35 PM

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