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

Individual error bars w/ a clustered bar chart??

I'm super new to Excel and I have a lab write-up due tomorrow and have been struggling with this one thing! So I've created a clustered bar chart with three separate categories and two bars within each category! I'm like 85% sure that my data is grouped within two series, the two series of either bar according to what shows when I open "Select Data." I'm looking to add error bars to the six individual bars with Standard Errors that I have calculated and stored in a workbook (I think it's called?) but can't find a way to do that? I've tried doing the "Format Error Bars" --> "Custom" --> "Specify Value" but it always groups the bars within the two series together! Seriously approaching my breaking point any help is much appreciated!!! I'm wondering if I need to completely redo the table my chart is drawing its data from so each bar is of a separate series? But I also need it to look the way it does now, visually-wise, if that makes sense so who knows if that's possible!

submitted by /u/Such-Kaleidoscope269
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#Excel compatibility
#rows.com
#Excel
#error bars
#clustered bar chart
#standard errors
#individual bars
#data series
#format error bars
#separate series
#workbook
#select data
#categories