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

How to create a box and whisker plot with two Y axis?

Our take

Creating a box and whisker plot with two Y-axes can effectively compare datasets with the same units but different scales. This approach allows you to visualize the distribution and variation of each dataset side by side, enhancing your analysis. To achieve this, you can utilize spreadsheet software that supports dual axes. By combining these boxplots, you'll gain clearer insights into the relationships between your data points. Let’s explore the steps to create this visualization and consider alternative methods if needed.

I'm trying to essentially combine these two boxplots, which have the same units but very different scales. Therefore, my goal is to create a secondary Y-axis, but I can't figure out how to do that for a box and whisker plot. Any solutions/other approaches I should try?

https://preview.redd.it/0ivs01c4nrzg1.png?width=1964&format=png&auto=webp&s=db6f5b01a6fd48f1fc9c31a6e3558a1aba412ad2

submitted by /u/AnalystOk1846
[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#rows.com#natural language processing for spreadsheets#generative AI for data analysis#enterprise-level spreadsheet solutions#Excel compatibility#AI-driven spreadsheet solutions#no-code spreadsheet solutions#Excel alternatives#data cleaning solutions#financial modeling with spreadsheets#box plot#whisker plot#secondary Y-axis#data visualization#boxplots#scales#units#combine#plotting