•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I graph error bars
Our take
Feeling stuck with Excel while trying to graph error bars for your bio assignment? You're not alone. Many users encounter challenges when navigating the web version of Excel, particularly when it comes to adding elements like error bars. Fortunately, understanding how to incorporate 95% confidence intervals can elevate your data presentation, making your insights clearer and more impactful. In this guide, we'll walk you through the steps to successfully add error bars to your graph, ensuring your work stands out.
Guys pls help, I’m so done with excel. I have a bio assignment where I have to graph 95% CI and I need to include error bars. I have created the graph, removed the trendlines but I can’t find error bars, I’ve watched so many videos but I’m on the web version. I have clicked on the graph, then instead of ‘chart tools’ mine only has chart and I can’t find chart elements or anything to add the error bars. Pls help me
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- 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]
- 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]
- 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]
Tagged with
#Excel compatibility#Excel alternatives for data analysis#rows.com#self-service analytics tools#business intelligence tools#collaborative spreadsheet tools#financial modeling with spreadsheets#error bars#graph#95% CI#Excel#chart tools#chart elements#bio assignment#trendlines#web version#videos#help#clicked#submitted