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

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#Excel compatibility
#Excel alternatives
#rows.com
#scatter plot
#SCADA
#Excel
#data