Creating a graph illustrating a channel cross section using stream velocity and depth

[connerlabure]

Hello, I would really appreciate some help creating a chart that illustrates the various stream velocities with respect to stream depth. I have the values for both velocity and depth, as well as section midpoint values. I just have to know how I would go about creating a chart like this in Excel. Thank you.
https://imgur.com/gallery/tSBx6V6

 

[Perpa]

conner,
you can create the cross section using the geometry shown in the imgur file you attached.
You need to change the x-values so they are increasing from left to right as I did in column A.
Select the x and y values for horizontal and vertical: ( I put them in columns A and B)

Channel Cross Section

	A​	B​
1​	x	y
2​	0​	0​
3​	0.1​	-1.1​
4​	0.5​	-1.5​
5​	1.5​	-1.7​
6​	1.9​	-1.9​
7​	2​	-2.5​
8​	2.1​	-1.8​
9​	2.3​	-1.7​
10​	2.5​	-1.4​
11​	2.6​	-0.9​
12​	2.8​	-0.3​
13​	2.9​	0​

Sheet: Sheet1

Then select Insert>Scatter>Scatter with Straight Lines...there is your plot.

Hope this is helpful.
Perpa