Individual error bars w/ a clustered bar chart??
Our take
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!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Custom error bars excel problemSo I have data for a project that I made into a line chart, which took me almost 4 hours because of the fact that excel didn't want to take my data as It was, it would see it as zero's instead of normal decimal numbers. After troubleshooting that I have another problem. I have the line graph I only need to add my custom error bars. The numerical value of the numbers should be big enough to show up, but excel just doesn't want to add them. I am selecting the range and everything correctly, I've tried with completely different numbers, different graphs and converting them etc nothing works. Please help me troubleshooting I am going insane. submitted by /u/alt_bc_im_a_pussy [link] [comments]
- Problem with getting charts to workHello, I am attempting to make a few charts for my assignment paper but excel is really not my strong suit. The core to my problem is I am trying to get error bars on my chart but i can't figure it out at all, any help would be useful. https://preview.redd.it/chh79lo3bl0h1.png?width=2768&format=png&auto=webp&s=820491ac27787a01c3a45f9fb4350ac02f999a69 I am happy to give more info i just really don't know what I'm doing. submitted by /u/yeeeeeeeeeen [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]
- How do I set error bars?I am trying to add error bars to a graph in excel. I keep selecting the deviation and once I press accept they disappear. I have tried everything: horizontal and vertical tables, copying and pasting the data and using it from there, using it fron the original table... I don't know what to do. It worked before but it doesn't anymore and Im desperate, I am currently breaking down submitted by /u/RaisinFree8943 [link] [comments]