•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Box and Whisker Formatting
Our take
Creating a box and whisker plot in Excel with log(concentration) on the y-axis can be challenging, especially when representing multiple compounds and sampling sites. To achieve a clear and readable format, consider grouping your data into sets of three bars for each compound, separated by gaps. This visual organization enhances clarity, but scaling the plot correctly is crucial to avoid a cramped appearance.
I’m trying to make a box and whisker plot with log(concentration) on the y-axis for the measurement of various compounds. I want to have a group of three bars then a gap followed by another group of 3 and gap….etc. Each group of three represents one type of data point (the particular compound being measured) and then each bar is a different sampling site. I have not been able to figure out the best way to format this in Excel and make it readable. Can anyone help with this? When I enter the raw data and create a blank “Gap” series, the plot is very small and not scaled well.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Making series specific categories on a box and whisker plotI am trying to make a box and whisker plot from a dataset with four series and many categories. Each series has its own unique categories. When I plot each series individually, the box and whisker plots look fine, but when I plot them together they get really squished. I found out that Excel plots each series as though it has data for each category, instead of its own set of categories. This makes the resulting boxes look really squished. I filled in some blanks with 0's to understand what was going on. https://preview.redd.it/7bzp08tnhp0h1.png?width=1579&format=png&auto=webp&s=147114c253d508a82fc0c86b83ed2362a6dada5d Is there a way to plot these different series together so that each of them has its own separate set of categories? submitted by /u/Real-Alternative-653 [link] [comments]
- Trying to create a box and whisker (?) chart without the box.https://preview.redd.it/s5g40zff2mtg1.png?width=1000&format=png&auto=webp&s=093040894eed1350759891f81509ab228024aba1 The above is what I am trying to re-produce in Excel. I have the data set for each football league, and the ELO Rating for each club in that league. Column A = League Column B = Team Column C = ELO rating No matter what chart type I use, I cannot get the data to display like above. The closest I can get is 'Box and Whisker' and then tick 'Show Inner Points', but this still leaves the Box and the minimum/maximum values that I don't want. I just want the data points on their own like above. Please help. submitted by /u/LinkTheFires [link] [comments]
- How to create a box and whisker plot with two Y axis?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]
- How do I make different standard deviation bars for each individual graph?I calculated the Standard Deviation for each individual data set but when I go to manually input the data into the error bars it does it for every bar instead of just one. How do I seperate them so each column can have their own individual standard deviation bar? submitted by /u/AniMASON16 [link] [comments]