Skip to main content

I am trying to make an overview of crosssections of infratsructure (a levee). I would like to plot all crosssections in 1 graph in excel.

 

I managed to make 1 excel per cross section, but I would like to plot them a bit like this:

 

This is made in Fme, but has 2 problems for me:

- 1: I can't 'turn off' certain cross sections since it's a png (that's why I want to do it in excel)

-2: I made an attribute column with cross section number, an x-value (-50 to 50) and a z value. I grouped them per cross section number. This causes the graph lines to go straight back from 50 to -50 on the next profile (the straigh lines). I would prefer not to have those lines.

So: how do I get 1 excel graph with all cross sections on top of eachother without the 'return lines'?

Be the first to reply!

Reply