Excel - How to plot a line graph with standard deviation

[@deepanshumangla2691]

Really simple explanation! Helped me! Thanks a lot

[@omac_achilles1436]

Thank you so much. The video was very easy to follow along with and helped me out a lot.

[@sakinahm3206]

Thanks so much from Malaysia😃

[@Gedlly]

i've been looking for this for ages! thank you so much!

[@dylanwang4290]

The 3 buttons to the right of the chart doesn’t exist when I click on my chart

[@fatemehyayjilo]

this was a life saver for me. thank you!

[@LucyCrisp]

Hi this has saved my dissertation thank you so much!

[@gerald9113]

This is perfect, thank you!

[@akabaigei4930]

Very helpful, thank you

[@deborahmathias4506]

Veryhelful and comprehensive

[@WyvernApalis]

Brilliant tutorial

[@acheaptechnerd7119]

Thanks for the tutorial! :D

[@thandarwinmaungmyanmar1431]

Thank you very much.

[@KarlinaTriana]

Thank you! Really helpful!

[@cchem8198]

thank you very much

[@ava_chavoshi]

Thank you!

[@ulfah_munirah]

Thank you 😊

[@nurazra7528]

Thank you.

[@myhorselifexx315]

I don't get the options on the site, please help i need to hand it in tomorrow

[@myhorselifexx315]

side

[@laurasmith_uos]

Apologies for the delay. I hope you got sorted in time for your hand in.

[@AsrasPOV]

​@@laurasmith_uos I have a similar issue, do you know what might be the problem?

[@laurasmith_uos]

@@AsrasPOV Hi, have you made sure you've physically selected the chart, I believe the side options only appear when you click on the whole chart. Also, are you using a free version of Excel, or what version are you using? I am using Excel 365 in this video. Many thanks

[@enzolong9085]

great, thank you

[@SurvivorDIY]

Thank you so much!

[@jasminec7483]

Thank you

[@aniketdahasahastra1034]

Thanks ♥️♥️♥️

[@ekenmaagwu1545]

Thank you.

[@thomasberli-biologiekst3969]

Thank you for the explanation. But by doing so, don't you end up doubling the SD on your graph, since you now plot the full SD in both positive and negative direction? In that case, would it be justified to only use Stdev/2 as the values that end up in the error bars?

[@laurasmith_uos]

Thank you for your feedback. To my knowledge this is the appropriate way to plot the data on the graph.

[@goosefs1373]

Thanks!

[@MuhammadAbdullah-nc3hy]

Excellent

[@hang5328]

Many thanks. Can you guide me on what to do if I want to show 2 lines of 2 groups of participant (such as male and female)?

[@laurasmith_uos]

Hi. As long as you have both sets of data on the same spreadsheet you can produce two separate lines. Either when you're creating the graph you can highlight both sets of data and add them together. Alternatively if you already have a graph created and wish to add a second line you right-click on the graph, select 'Select Data' and then you can 'Add' a new 'Legend Entries (Series)'. On the pop up, under 'Series values' select/highlight the cells which you wish to use as your second line. I hope this helps.

[@attatross]

When I click on more options after clicking on trendline it shrinks my graph into a ball

[@alialkolaib9949]

it gives me the bars in horizontal instead of vertical, anyone can helps me please?

[@sinhaeng9507]

Hello Laura, is it possible to label the data of SD on the line graph?

[@laurasmith_uos]

Hi Sinhaeng. This is not something I have commonly performed. This is I way I have found to do this, once the chart is plotted (including the SD), select the chart, then Chart Elements (+ in top corner of the chart), select the arrow next to Data labels and then More Options. Select the icon for Label Options (hover over them if you're unsure), then select Label Options again. By default this will plot the data labels for Average (mine does, I'm not sure on everyone's), in order to change this select Value From Cells, then select all of the SD values you wish to label. Once you have selected the SD values and selected OK, both the Average and SD values should appear as Data Labels. In order to remove the Average from the Data Labels, on the right hand window pane deselect Value and this should remove the Average values from the data labels and leave only the SD. I hope this helps. Many thanks.

[@njm1259]

Live saver

[@yasinsamedmert]

i love you

[@Oculus_idealistae]

Thank you!