1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Stacked scatter plot with same y-axis for readability

Im working with SCADA and pulling together data from a model to compare the 2 at a couple of different locations.

Is there a way to stack 3 graphs in excel without completely manually doing it?

the data is all for the same week in sub minute increments, so needs to be a scatter plot. and y-axis is all the same so its not a like a secondary axis is beneficial in this case.

below is the plots with all the data, very hard to parse unless someone explains what's going on.

https://preview.redd.it/cgyalit9wyzg1.png?width=1426&format=png&auto=webp&s=b03a3d9022a3efc482d6d3161a52186c1c745f36

below is what I'd like the graphs to look like, done in ppt. Kind of annoying to do manually and there's a couple of other locations I need to do this for, so if there's a better solution, let me know!

https://preview.redd.it/9003h0vwvyzg1.png?width=848&format=png&auto=webp&s=e5af1d78cde58175ed5451fbb4e85f06a4f89815

submitted by /u/MyGoddamnFeet
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article