Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Want help to draw a circle in a graph via point data and axis in Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 25-02-2012
Member
 
Join Date: Feb 2012
Posts: 9
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 x-axis at the x-value and then draw a circle with radius (y) around that point ensuring that I intercept the x-axis 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 hand-drawing them over the plotted data points.

Reply With Quote
  #2  
Old 25-02-2012
Member
 
Join Date: Aug 2011
Posts: 688
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:
  • =$B$1+$D$1*COS(A3*PI()/180). In C3 enter this formula
  • =$C$1+$D$1*SIN(A3*PI()/180). Select B3:C3, and double click on the little
there will be a black square on the bottom right corner of the selection, which will fill these formulas down to row 39. Select & copy B3:C39, select the chart, and use Paste Special to add this data to the chart as a new series.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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 25-02-2012 10:47 AM
Need help to locate point of intersection in two line graph in Excel Iyyappan MS Office Support 1 25-02-2012 10:19 AM
Draw a Tangent in Microsoft Excel graph RYAN$ MS Office Support 4 13-01-2012 03:12 PM
How to draw a circle in Excel 2007 Daksha90 Windows Software 5 13-06-2011 08:20 AM
How to graph daily data in to monthly excel sheet Sunny55 Windows Software 2 04-06-2009 08:32 PM


All times are GMT +5.5. The time now is 07:12 PM.