smooth curve

D

dee

Good morning. I have inserted a 12 x 12 table with x axis labeled from 0-6
seconds and y axis from 0 - 1200 feet. I am now trying to draw a smooth
half of a quadratic curve (arc) from the 600 ft on the y, hit required
points all the way down to x axis at 6 sec. The curve must be a smooth
quadratic curve.

first, I tried using the auto shapes: curve. It was very difficult to be
accurate enough to hit all the required ordered pairs on the way down. When
finished, I went back to edit points, but it still looked a little jagged in
places. Next, I tried "free form" with the same results.
How do I get a perfect arc, hitting on the table, and look like a quadratic
function?
thanks for any input. (version2003)
dee
 
E

eldon.l.lehman

dee said:
Good morning. I have inserted a 12 x 12 table with x axis labeled from 0-6
seconds and y axis from 0 - 1200 feet. I am now trying to draw a smooth
half of a quadratic curve (arc) from the 600 ft on the y, hit required
points all the way down to x axis at 6 sec. The curve must be a smooth
quadratic curve.
This may be more than requested, but can provide future changes. Excel
would be a great tool for this project. With the parabolic curve
demands and the one mentioned event, an equation in Excel can provide
good results. Assuming that there was no initial velocity, the
acceleration is 33.3 ft/sec squared. Cells A1-A7 could be populated
with 0-6 respectively. The equation =0.5*33.3*A1^2 can be placed in
cell B1 and copied down through B7.
Upon blocking A1:B7 the chart wizard can provide an "XY(scattered)"
chart with smooth lines. The chart enhancements with the proper labels
and axis scales make it more scientific. When finished the choice of
Place chart "As new sheet" puts it in as its own item. Selecting the
chart and using shift+Edit, the drop down menu has "Copy Picture"
listed. The "As shown on screen" bring the
"Format" area to life. Chosing "Picture" will possibly give a message
that it is too large and will be truncated. That seems to be ok.
Now in Powerpoint "Edit", "Paste Special", "Picture(Windows Metafile)"
will help the presentation file remain small.
This procedure does not allow linked changes, but it can be easily done
in Excel and resent to Powerpoint. This was written from Excel '97 and
Powerpoint 2003, so some placement of menus may have changed in Excel
2003.
Hope this helps.
 
D

dee

hmmm...this sounds like a good way to go but I have only a small knowledge
of spreadsheets.
dee
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top