![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Apr 2002
Posts: 2
|
I was wondering if anyone can help me out, I have a number of sets of data comprising two numbers each in the x domain (y=0), I need to plot a semicircle between these two numbers with the flat edge along the x-axis and the arc in the positive y.
Any suggestions, I've been told I can do it and that I need the equation of a semicircle if that's any help? |
|
|
|
|
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Helena, MT
Posts: 13,690
|
Use the XY (Scatter) chart format connected with smooth lines. You will need a lot of data points to produce a smooth curve.
|
|
|
|
|
|
#3 |
|
New Member
Join Date: Apr 2002
Posts: 2
|
But how do I find those points?
|
|
|
|
|
|
#4 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Helena, MT
Posts: 13,690
|
If I remember right from college math, (It's only been 35 years), the formula for a circle graph is x^2 + y^2 =r^2. For a semicircle, omit the negative y values
|
|
|
|
|
|
#5 |
|
Board Regular
Join Date: Feb 2002
Posts: 74
|
Assuming that you want the semicircle to start at the origin and be in the upper-right
quadrant of the plane, with the flat part of the semicircle along the x axis, then your equation would be: (x-r)^2+y^2=r^2 or y^2 = 2rx - x^2 or y = (2*r*x - x^2)^.5, for 0<=x<=2r
__________________
"Interfere? Of course we should interfere! Always do what you're best at, that's what I say!" -- The Doctor, Nightmare of Eden |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|