Is it possible somehow to make a maximum graph out of several other graphs in excel like the red dashed line in the example? I'm trying to automate the graph making via vba and can't figure out this.

Thanks in advance!

CodePudding user response：

It is not possible to create a maximum graph out of the graphs of two datasets.

However, it is possible to use the =MAX() worksheet function to create a new dataset and make a graph out of that newly generated dataset: