Forum Discussion
Plot defects on graph
Hello All,
I am not very good with graphs although I believe using a graph would be the best way of doing this.
Im making a spreadsheet that will take a "box" based on a defects axial start, length, circumferential center and width and be colour coded based on defect type, and then plot this information on a graph. the graph is more so used to represent the pipes surface.
Please see the attached for an example. I have seen some companies do it where the final product looks like the imitation graph that I drew and others where they actually use a cylinder for the pipe shape. Hopefully this is enough information to make sense of what I am after.
P.S. the axial distances can sometimes shift. By that I mean the extents. Sometimes the x axis will be from -2m to +18m and other times we will get all positive numbers. Basically which part of the line is exposed. and the defects fall within that area. and then obviously 0 - 360 is always going to be 0-360 degrees. so the y axis never changes.
If there are any questions or if I didnt make sense please let me know.
I can get you something like this:
In the linked-to workbook below a little macro which draws a fresh chart each time Button 1 is pressed.
If the labels are a bit confusing you can move one with the mouse and a line will appear showing which shape it belongs to:
Link:
https://app.box.com/s/pecl6xnz2l8gbwf0z3vryzxvu7bvax65
3 Replies
I can get you something like this:
In the linked-to workbook below a little macro which draws a fresh chart each time Button 1 is pressed.
If the labels are a bit confusing you can move one with the mouse and a line will appear showing which shape it belongs to:
Link:
https://app.box.com/s/pecl6xnz2l8gbwf0z3vryzxvu7bvax65
I believe the closest you can get is by creating a bubble chart where the bubble size is based on the "area of the defect". Not sure though if that is what you had in mind.
This looks incredibly close to what I am trying to do. Rather than me providing 4 positioning measurements, would it make more sense to only have two? would that help with making the width dimension possible? example rather than using ax start, orientation, length and width, (4 variables) i would only provide the coordinate for axial start and circ start as one set of coordinates and then the axial end & circ end as another set? Like i said I am terrible with graphs but just trying to look at it from another angle
