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

Our take

Creating stacked scatter plots in Excel can enhance data readability, especially when comparing SCADA model outputs across multiple locations. By aligning the y-axes, you maintain consistency and clarity, allowing for easier interpretation of trends within sub-minute increments. While manually adjusting each graph can be tedious, there are efficient methods to automate this process. We invite you to explore innovative techniques that streamline your graphing tasks, ensuring your data visualizations are not only informative but also visually appealing, enhancing your overall analytical experience.

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]

Read on the original site

Open the publisher's page for the full experience

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