Connecting points in a graph

**rshin2020** · 01-06-2010, 02:55 AM

I practically gave you the information you wanted! I just need to connect the caps of a point to the next point. The lines have to be parallel. why 3 lines? its because the first and the third has to come from the caps of the point A and the second from right in the middle. Its okay if you find it difficult. Sorry for the trouble. I'll just ask somewhere else. Thank you for your time.

**Andy Pope** · 01-06-2010, 06:22 AM

If by caps you mean error bars then you are using custom values which means you have values within the worksheet.

You need to use additional xy-scatter data series plotting points calculated via formula based on the xy-point and the error values.

As your example files only contain links to the original data file on your server we can not provide a more complete answer.

**rshin2020** · 01-07-2010, 02:58 AM

I appreciate you understanding my problem. I have found a solution to it but using VB code. I do not understand the code that well. Is it alright to post it here?