•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I apply custom error bars to specific points of my graph?
Our take
If you're new to Excel and feeling overwhelmed by the process of applying custom error bars, you're not alone. Many users encounter the same issue when they find that their error bars apply uniformly to all data points. Fortunately, there's a straightforward way to customize error bars for individual points on your graph. By following a few simple steps, you can tailor each error bar to reflect the unique uncertainties of your data.
Hi, I’m new to excel and don’t know much. I’ve set up my data points on a graph and when I try to apply custom error bars, it gives it to every point on the graph. Is there a way I can make a unique error bar for each point on the graph? Thanks
[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]
- 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]
- 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]