• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to Draw a Polar Chart

nagovind

Member
Dear All,

Please refer to the attachment

Please advise how to draw this polar chart with the degrees 0 to 360 degree and with an Arrow starting from origin and touching the edge of the circle

Regards
Govind
 

Attachments

  • polar.jpg
    polar.jpg
    46.5 KB · Views: 20
Hui !
Excellent
Thank you very much for the attachment

Exactly this is what i required. But i need to study the attachment to understand how this works

Hats off

Regards
Govind
 
The Circles and Arrow are Named Formula
The straight lines are ranges
The text is Labels of a series that has no line, just a label
 
Dear Hui,

Please help to understand, I'm unable to refer to the actual reference cell
All cases
How this Arrow head is working with ONE point data

Please elaborate
upload_2014-12-16_14-26-9.png
 
They are referring to Named Formula
Goto the Functions, Name Manager menu
Explore the various names
 
Dear Hui,

Thank you very much for your example file
You are the expert
By knowing the logic and using the Named ranges it is done
Sorry it is very complex to understand for me as i'm not good in named ranges
Is there is any way to plot the chart without using names ranges
Please advise
Sorry
Please

Govind
 
Dear Hui,

Please advise

Inc2_ variable = {0,1}
What is 0 and 1

Is it x and y coordinate of the Arrow at the end (Height of Arrow)

In general please advise the meaning if {0,1} data
 
Inc, Inc2_ and Inc3_ are arrays that are used to establish the base lines of the various components of the chart

Inc is an array from 0 to 360 degrees in 1 degree increments and then converted to radians
It allows the circles to be plotted by working out the X (Cos) and Y (Sin) components for each point

Inc2_ is an array for the arrow

The arrow starts at the origin which has a value of 0 and extends to a length of 1 the outer circle
By using this array I can multiply it by the Angle and length to work out the cordinates of the two ends of the arrow. The tricky part is that because the origin is at zero, multiplying the array by the angle and length of the arrow will return 0 for the x,y values at the centre and the x,y cords for the pointy end of the arrow

Inc3_ is the same in that it is used for the starting coordinates for the straight lines
 
You asked in a previous post about why use Named Formula

1. They are super fast
2. They remove the workings away from simple user interaction/tampering
3. It removes clutter from your worksheets
eg: The circles would require 360 rows x 3 columns to do in cells
 
Hui,
Thank you for your reply
Awesome
With your expertise in Mathematics you are excelling in excel!
Thanks for your notes about named ranges
I got it. I'm sure within a week i will understand thoroughly about the file
Thanks for your help
Regards
Govind
 
Dear Hui,

Please advise the usage of this formula. Why offset formula is used
Why this from A1 to 361 where the sheet does not have any data in many cells of A23 A34 and after A59

=RADIANS(ROW(OFFSET(Sheet1!$A$1,,,361,1))-1)
 
Hi Govind ,

There is no reason to use this ; this is used when the start and / or the endpoints ( 1 and 361 in this case ) are dynamic or cell references. In this case , all we want to do is generate an array of values for all angles between 0 and 360 ( 360 is the same as 0 ) in increments of 1.

The construct :

=ROW(1:361) - 1

will do this. We cannot directly specify 0 through 360 , because the usage ROW(0) will generate an error , which is why we use ROW(1:361) and then subtract 1 from this.

To make it more clear that we do not wish the parameters to vary , we should use :

=ROW($1:$361) - 1

which will generate the array :

{0;1;2;3;4;5;6;7;8;9;10;.....;350;351;352;353;354;355;356;357;358;359;360}

Wrapping the RADIANS function around this will convert the angle in degrees to the angle in radians.

Hence the overall formula can certainly become :

=RADIANS(ROW($1:$361) - 1)

Note that in this case using the $ sign does not prevent Excel from changing this to :

=RADIANS(ROW($1:$362) - 1)

if you insert rows between row #1 and row #361.

Using the formula Hui has used will prevent this problem.

Even if rows are inserted , the formula will not change , and the array will remain between 0 and 360.

Narayan
 
Hi Narayan,

Thank you so much for your detailed reply

I got it

Thanks Hui
Thanks Narayan

Thanks for sharing your expertise

Regards
Govind
 
Back
Top