

 Thread Tools  Search this Thread 
#1
 
 
Want help to draw a circle in a graph via point data and axis in Excel
I am working with more circles and I want to draw a circle on my graphs using a data point (x,y) values to make the circles. Now if I was using a compass, I would set my compass point on the xaxis at the xvalue and then draw a circle with radius (y) around that point ensuring that I intercept the xaxis at distance (x + y), (x  y) and point (x,y). I am trying to figure out if there is someway I can conveniently construct these circles in excel rather than printing out the graph and then handdrawing them over the plotted data points. 
#2
 
 
Re: Want help to draw a circle in a graph via point data and axis in Excel
I haven't done Mohr's Circle since gradual school. Knowing the (Xc,Yc) coordinates of the circle's center, and the circle's radius R, you can calculate points of the circle, then plot the points on the chart: Put Xc, Yc, and R into B1, C1, and D1. Enter 0 in A3 and 10 in A4. Select A3:A4, then drag the black square at the bottom right corner of the selection downward until you have filled from 0 to 360 in steps of 10 (down to A39). In B3 enter this formula:


Tags: microsoft excel, microsoft office, office application, spreadsheet 
Thread Tools  Search this Thread 

Similar Threads for: "Want help to draw a circle in a graph via point data and axis in Excel"  
Thread  Thread Starter  Forum  Replies  Last Post 
Y axis label cutoff in Excel graph  Hache hi  MS Office Support  2  25022012 11:47 AM 
Need help to locate point of intersection in two line graph in Excel  Iyyappan  MS Office Support  1  25022012 11:19 AM 
Draw a Tangent in Microsoft Excel graph  RYAN$  MS Office Support  4  13012012 04:12 PM 
How to draw a circle in Excel 2007  Daksha90  Windows Software  5  13062011 09:20 AM 
How to graph daily data in to monthly excel sheet  Sunny55  Windows Software  2  04062009 09:32 PM 