|line and points in xychart||fernando cinquegrani||3/1/02 2:07 AM|
|line and points in xychart||fernando cinquegrani||3/1/02 5:02 AM|
"fernando cinquegrani" <f.cinq...@libero.it> ha scritto nel messaggio
now i do this in connecting centers of
|line and points in xychart||Tushar Mehta||3/4/02 3:22 PM|
[This followup was posted to microsoft.public.excel.charting with an
email copy to fernando cinquegrani.
Please use the newsgroup for further discussion.]
I would suggest that you not use shapes to connect data points on a
|line and points in xychart||fernando cinquegrani||3/5/02 12:34 AM|
i would fill the polygon defined by lines.
please, see cluster.exe or scatter.exe
in my excel page (hhtp://www.prodomosua.it/ppage02.html).
i select a range of datapoints, then compute
the convex hull (in italian: inviluppo convesso), then create
a new dataseries with lines. how can i fill this polygon?
|line and points in xychart||Tushar Mehta||3/5/02 6:42 AM|
I couldn't tell from the examples on the web page what exactly you want
to do. And, its been some time since I had to worry about constructing
a convex hull. So, if what you want to do is create an object that
closes on itself, just plot the first data point once more as the last
data point. This would have to be in a XY Scatter chart. For example,
to create a rectangle, plot (x1,y1), (x1,y2), (x2, y2), (x2, y1), and
In <1l%g8.4319$uN5.1...@twister1.libero.it>, fernando cinquegrani
|line and points in xychart||fernando cinquegrani||3/5/02 11:45 AM|
Thanks for your interest, but...
in my examples i create a new close polygon
(the convex hull) yet.
i want to fill this with a colour.
i think i have to draw the polygon as a shape.
i now draw this polygon as shape (not in examples),
and i fill it with a colour.
but for find the nodes of my polygon, i need the
position in chart of each point.
which is the position (left, top) of a generic point in a xychart?
the statement dataseries(a).points(b).left=...doesn't exist.
now i use the datalabel (not visible) center of this point.
this process is very slow and it is impossible to
update the chart in real time if i change the data.
(excuse me, but i dont speak english)
|line and points in xychart||Jon Peltier||3/5/02 11:55 AM|
No problem, I think I know what you want. To just draw a closed shape, you
Since you want to fill in the shape with some other color, however, you really
This works for an XY Scatter chart (I assume it will crap out for a line
''' START THE CODE ---------------------------------------
Set myCht = ActiveChart
Set mySrs = myCht.SeriesCollection(1)
Xnode = Xleft + mySrs.XValues(Npts) * Xwidth / (Xmax - Xmin)
Set myBuilder = myCht.Shapes.BuildFreeform(msoEditingAuto, Xnode, Ynode)
|line and points in xychart||fernando cinquegrani||3/5/02 4:21 PM|
|line and points in xychart||fernando cinquegrani||3/5/02 5:41 PM|
Xnode = Xleft + (mySrs.XValues(Ipts) <<< - Xmin >>>) * Xwidth / (Xmax -
because the scale doesn't start by zero (MinimumScale).
|line and points in xychart||Jon Peltier||3/5/02 7:16 PM|
|line and points in xychart||fernando cinquegrani||3/9/02 6:03 AM|
Set myShape = myBuilder.ConvertToShape
is frequently in error when the
chart is very little (points quite near).
do you know why?
how can i obviate?
1. the addin cluster.xla, where i use your suggestion, is on line
2. for a best performance of your code, define
Dim Xnode as Single, ...
"Jon Peltier" <jonpe...@yahoo.com> ha scritto nel messaggionews:uErS$0LxBHA.1644@tkmsftngp07...
|line and points in xychart||Jon Peltier||3/12/02 2:35 PM|
When you draw a shape manually, if you make a point very close to another
|Re: line and points in xychart||Flavio Henrique da Silva||3/14/17 8:38 AM|
Please, Jhon Peltier and Fernando Cinquentani,
have a solution for this problem for error on ConvertToShape for point very close to another point ?
|Re: line and points in xychart||Jon Peltier||3/14/17 12:50 PM|
Are you experiencing a problem? There really doesn't seem to be a problem when drawing the shape programmatically, since the points are added explicitly. When you do this manually, Excel sees you click twice close together and decides that you are finishing with your drawing.
|unk...@googlegroups.com||3/14/17 3:47 PM||<This message has been deleted.>|
|unk...@googlegroups.com||3/14/17 3:51 PM||<This message has been deleted.>|
|unk...@googlegroups.com||3/14/17 3:54 PM||<This message has been deleted.>|
|Re: line and points in xychart||Flavio Henrique da Silva||3/14/17 3:56 PM|
Hi Jhon Peltier,
same problem of Fernando Cinquengrani at last message of him in this thread.
same problem of Fernando Cinquegrani:
|Re: line and points in xychart||Flavio Henrique da Silva||3/14/17 3:59 PM|
Hi Jhon Peltier,
|Re: line and points in xychart||Jon Peltier||3/15/17 9:40 AM|
I don't know why you got this error. I have tested with points "quite near" without problems.
What version of Excel are you using?
What does your data actually look like? ("Quite near" isn't very descriptive.)
|Re: line and points in xychart||Flavio Henrique da Silva||3/15/17 1:04 PM|
Jhon, I'll put the attached file in another forum if you wish, here I can not attach.
I have now sent you the file in an email.
COPY OF EMAIL
Excel Vba Shapes to Connect Points Charts
Hi, Jhon Peltier,
i sent to you sample file with macros in this email.
I could put it on the MR.ExcelForum if you wish
I want connect the point of chart XY to create a shape clone of chart of 2 ways, 1solid line shape and 1Outline Shape.
your code works with more simplex charts but no with my complex chart.
i need change your "Dim as Integer" to "Dim as Long" to works with more simplex.
i need change the location of "Next" before "ConverToShape" to final of code to avoid the problem of shape close before a correct moment.
the chart (XY Scatter dots only) have 1series with very number of points with contiguous and non-contiguous points complex design.
Excel 2013 32bit Original - Win7.
please work with sample file logo if possible.
thank you very mutch.