Oval graph with angle and drops from the circle

[ashfaq267]

Hello Mr.Excel,


Can you help me with the below task.


I wanna make an oval graph using angle and drop at each angle.


Eg:


0 0

10 -14

20 -53

30 -113

40 -186

45 -225

50 -264

60 -338

70 -397

80 -436

90 -450


ie : When comes to 90 deg the radius becomes (actual radius @0 deg - 450)


this graph i want to make for 90 or 180 or 270 or 360 , as per the data available with me.


Can you help.


Please let me know if you didn't undrstnd the task.


Ash

 

[Faseeh]

Hi Ashfaq,


Welcome to the "Chandoo's" forums...(this is not Mr.Excel's Blog!!


In your given data the first column is radius and the second one is angle is that correct??


Faseeh


[@Hui: My status is changed, thanks for the responsibility ]

 

[ashfaq267]

Hello Faseeh,


Tnx


I gave him that name after seeing his posts nope... the first column is angle and the second, radial drops from the actual radius.


Ash

 

[Faseeh]

Hi Ash,


See this file:


http://dl.dropbox.com/u/60644346/Radius_Angles.xlsx


It will be helpful if you add some pic or jpg of the graph you want, if this one is not appropriate or just use drawing tool of excel to draw and image and upload the sample file.


Faseeh

 

[ashfaq267]

Hello Again,


Thanks for the file. but it comes only as point i need it in line. also the values are only for 90 deg , It shows for the complete 360 deg.


I have a pic i could share , but donno how to share thru this.


May be this will help you: http://www.google.co.in/imgres?start=140&um=1&hl=en&client=firefox-a&sa=N&rls=org.mozilla:en-USfficial&biw=1110&bih=592&tbm=isch&tbnid=iDAVLjtwQVzmMM:&imgrefurl=http://www.sciencedirect.com/science/article/pii/S0888327011003025&docid=YdnD-Zv_sZiJRM&imgurl=http://ars.els-cdn.com/content/image/1-s2.0-S0888327011003025-gr10.jpg&w=724&h=354&ei=SZhuUP_EOorSrQfXl4CoBg&zoom=1&iact=hc&vpx=467&vpy=153&dur=738&hovh=157&hovw=321&tx=151&ty=59&sig=110424939889423620224&page=7&tbnh=85&tbnw=173&ndsp=25&ved=1t:429,r:22,s:140,i:229


Sorry for the long link . pic on the right side , if the pic has opened as a result.


Ash

 

[Hui]

Ashfaq267


To share files Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook


Faseeh's file works well

Select a point on the Chart, Right Click, Format Series, Set the line color to what ever you want

You can insert rows to extend the series to 360 Degrees and just copy the formulas above

 

[ashfaq267]

Hello,


I have done it , eventhough it is not as i wanted it. Thanks for the file Faseeh , That gave me the idea of doing it in this way..


http://www.2shared.com/document/RuK_ZUBS/Radius_Angles_new.html


Ash

 

[Faseeh]

Hi Ash,


You are welcome!!


Faseeh