Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 15th 17, 04:40 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2017
Posts: 1
Default line and points in xychart

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.)

- Jon
http://peltiertech.com
_______

On Tuesday, March 14, 2017 at 6:59:14 PM UTC-4, Flavio Henrique da Silva wrote:
Hi Jhon Peltier,
same problem of Fernando Cinquengrani at last message of him in this thread.
same problem of Fernando Cinquegrani:
the statement
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?
''http://www.prodomosua.it'



  #2   Report Post  
Old March 15th 17, 08:04 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2017
Posts: 2
Default line and points in xychart

Em quarta-feira, 15 de março de 2017 13:40:33 UTC-3, escreveu:
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.)

- Jon
http://peltiertech.com
_______

On Tuesday, March 14, 2017 at 6:59:14 PM UTC-4, Flavio Henrique da Silva wrote:
Hi Jhon Peltier,
same problem of Fernando Cinquengrani at last message of him in this thread.
same problem of Fernando Cinquegrani:
the statement
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?
''http://www.prodomosua.it'



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.

https://groups.google.com/forum/#!searchin/microsoft.public.excel.charting/nodes$20points%7Csort:relevance/microsoft.public.excel.charting/AgWMOIKU4Do/w1JYa3PIt5kJ

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.
Flavio Henrique.
--------------------------------------------------------------


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Points on Line Chart Douglas Carr Charts and Charting in Excel 1 January 29th 10 07:34 PM
How to format a line between two points? Mark Stephens Charts and Charting in Excel 6 April 20th 09 01:25 AM
How to format a line between two points on a line chart? Mark Stephens Excel Programming 2 March 31st 09 12:12 PM
SetSourceData for UserType XYChart with two series PBezucha Charts and Charting in Excel 2 February 18th 08 02:01 PM
a line between 2 points Daniel Charts and Charting in Excel 2 May 10th 05 01:48 PM


All times are GMT +1. The time now is 05:57 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017