View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default how to dump freeform coordinates (a plot shape)

There is no way to extract the data directly, and in any case it's unlikely
to conform to any particular physical representation of your model.

If you really want to get some numbers, you can try this. Brian Murphy has
determined that the smoothed lines are represented by bezier curves. More
details he
http://www.xlrotor.com/Smooth_curve_...ample_file.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Durango" wrote in message
...
" unknown coordinates" - they are unknown to me, but not to Excel that
plots them; how do I get the values that are plotted between my known
points?
(ex: I have coord every foot, I want every inch along the line; is there a
dump feature for the nice curved lines that excel plots?)

"Jon Peltier" wrote:

First of all, the help topic you are reading describes how to use the
shape
as a label, using text from a particular cell.

Second, a chart plots the data you provide it, so you'll have to figure
out
how to provide unknown coordinates.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Durango" wrote in message
...
Help sais: Display cell contents in a shape or text box
Click the AutoShape or text box you want to link.
In the formula bar, type an equal sign (=).
Click the worksheet cell that contains the data or text you want to
link
to.
Press ENTER.
Note You cannot use this procedure in a freeform, scribble, line,
- but this is what I want! I want to process the line data.
I have a coarse set of x,y data that look nice when I get a shape
between
the point, not just straight lines between points. How can I get/dump
an
improved/ more dense set of coordinates positioned at the smooth shape?

This Q is for a preliminary solution (my set of x,y data came from a
CAD
program), my real problem is that I have the perfect shape in AutoCad,
but
I
don't know how to dump out coordinates for that line either.