•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I need to create a chart for a min-max data set but none of the chart types seem to work
I want to compare the unstretched-stretched measurements of skirt waistbands across sizes and styles. What I envision is a chart where the x axis is inches, the y axis is sizes, and the min-max measurements are horizontal bars color coded by style. Mock-up is below. Data is below that. I've tried every type of chart in excel and the one that seems to fit what I want is a box and whiskers. However, I can't figure out how to structure the data so it displays the way I want it to.
[link] [comments]
Want to read more?
Check out the full article on the original site
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
#Excel compatibility
#Excel alternatives
#rows.com
#natural language processing for spreadsheets
#chart
#min-max
#data set
#box and whiskers
#skirt waistbands