Pipe Diagram Chart - Best Option

[ScoRat]

Hello,

I was reviewing the work from another excel file from someone who no longer works at our company. They used an excel chart to create a quick pipe network diagram and I was hoping to replicate this.

Pipe Network Example.png

Does anyone have any tips as how how the above image would be achieved? My guess is a scatter plot diagram with a VBA macro that extracts the points for each point.

Any advice or input is greatly appreciated!

Many Thanks

[MrShorty]

I don't know that VBA is necessary -- it really just depends on which programming language (spreadsheet formulas or a more traditional programming language) you prefer.

Personally, I would lean away from VBA and just use spreadsheet formulas. I agree that it looks like a scatter chart. I cannot tell what values to use for x and y, but I assume that you know what to use or how to calculate x and y for each important point.

1) For the horizontal lines, I would:
1a) Enter a column of x values. arrange the values so that the plot will begin at the upper left point, continue across at constant y until the end of that line. Then leave a blank row and repeat those x values for the next horizontal line. Repeat until I have 5 lines worth of x values. The blank row is critical for getting the last point of the of one line to not connect to the first point of the next line.
1b) Enter a column of y values. Enter the appropriate y value for the first line adjacent to the first set of x values, then enter the next y value for the next set of x values, and so on.
2) Select these two columns and insert my scatter chart (lines with markers). Format chart until it looks right.
3) Then enter a column for x values for the polygon, with an adjacent column containing the appropriate y values.
4) Bring up the select data dialog and add a new series, using these x and y values.
5) Format the new series appropriately.

Does that help?