Chart Type from 0 to 180 degrees

N

nkclarkey

New Member
Joined
Mar 13, 2007
Messages
1
I would like plot values on a semi circular looking graph where 0 degrees is the left (pointing west) which rotates clockwise to 180 on the right (pointing east). sample data would be the following;

0, 3
1, 5
..
..
..
180, 2

So the values on the left would be plotted as actual degrees and the values on the right would be the radial value from the origin of the semi-circle.

I hope my problem description makes sense to someone and I hope someone can help me.

Thanks
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Sort by date Sort by votes
Hi
if you plot your data from 0 to 180 as sin(A1*PI()/180) you can get semicircular graph on XY plotter. your explanation is not clear enough to say how to go about. Pl. explain. Also tell us the purpose of this exercise.
Ravi
 
Upvote 0
Hi,
I agree with ravishankar

If cells A1 and B1 contains degrees and radial values, respectively, you may convert to X, Y coordinates as follows:

X1: =-B1*COS(A1*PI()/180)
Y1: =B1*SIN(A1*PI()/180)

Repeat for all your points and use xy plotter.

Ciao
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
Plotting 3 points per data set in lollipop-type chart
Replies
2
Views
228
charllottesu
C
N
  • Question
2-step Dynamic Ranges and Charts
Replies
0
Views
136
Nick Loughton
N
B
  • Question
Interpolation of several graph plots.
Replies
0
Views
173
Browner
B
M
  • Solved
Display textbox from listbox - getting 381 error
Replies
4
Views
198
maiatanaka
M
C
  • Question
VBA-Photos to be imported from Sharepoint Site rather than local drive
Replies
1
Views
158
Micron
M

Forum statistics

Threads
1,214,646
Messages
6,120,716
Members
448,985
Latest member
chocbudda

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top