•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to create a box and whisker (?) chart without the box.
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.
[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]
- 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]
- Stacked scatter plot with same y-axis for readabilityIm 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]
- How to make Line Charts automatically not start from 0?Hi guys, I am working on a calculator made in excel. It pulls the data from one sheet and in another one it displays some kpi summaries, insights and line charts. I am not happy with how the line charts look like because it always starts from 0 and my line is sitting on the top third of the chart, while the bottom two thirds are just empty space. I tried a few things, such as adding helper columns in the chart and making them invisible, to automatically adjust it every time new data is uploaded but the min is always 0 and I have control over the max only, which lowers the position of the line but makes it even more straight so it's still unappealing. I do not want to use VBA as it's something we are sending to clients, and if they do not enable macros then it's for nothing. Are there any solutions you guys might know? I am using the desktop version of excel, on mac. Thank you submitted by /u/Think_Jello_8525 [link] [comments]
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#Excel compatibility#Excel alternatives#rows.com