I want to show the data points about the test and control samples in a vertical dot plot/scatter plot using Excel 2016. Have tried in various ways to figure it out, but could not. Can anyone please help in making the same?
Dear Wulligundam:
As John I recommend you to use a statistical package to do so, it's easier. But this graphics can be done with excel, and I'll show you some tricks.
First, I think if you are doing a vertical scattter plot you do not need to include error bars, because you are showing the actual dispersion of data.
Mean or median (depending on your data) could be easily shown treating them as a different data series, and looking for a type of marker similar to a horizontal bar.
Standard error (or standard deviation) can be easily shown when you add another data series to include the mean. First you calculate the dispersion measure you want in a blank cell. Then click on the chart. It should appear different symbols at the right corner of the graph. Click on the cross. Click on the sliding menu right of the Error Bars statement. Click on more options.
A sliding menu will be displayed on your right. Choose the bar plot logo. In the bottom of the menu you'll find "Error Amount". Select Custom and then select for upper and lower bounds the cell with the calculation of your dispersion measure.
By doing so, I did the graph I attach in a simple excel sheet you can use as a guidance.
In the following paper, the authors show how a univariate scatterplot should be, and also provide beautiful excel templates in order to do so (as a supplemental document). But they did not include error bars. I recommend you use these templates since they are carefully designed to be easily used.
I think you will need a statistical package to do that. excel might not be able to establish the relationship using scattered plots. Look for SPSS, Stata, GENSTAT software.
Dear Wulligundam:
As John I recommend you to use a statistical package to do so, it's easier. But this graphics can be done with excel, and I'll show you some tricks.
First, I think if you are doing a vertical scattter plot you do not need to include error bars, because you are showing the actual dispersion of data.
Mean or median (depending on your data) could be easily shown treating them as a different data series, and looking for a type of marker similar to a horizontal bar.
Standard error (or standard deviation) can be easily shown when you add another data series to include the mean. First you calculate the dispersion measure you want in a blank cell. Then click on the chart. It should appear different symbols at the right corner of the graph. Click on the cross. Click on the sliding menu right of the Error Bars statement. Click on more options.
A sliding menu will be displayed on your right. Choose the bar plot logo. In the bottom of the menu you'll find "Error Amount". Select Custom and then select for upper and lower bounds the cell with the calculation of your dispersion measure.
By doing so, I did the graph I attach in a simple excel sheet you can use as a guidance.
In the following paper, the authors show how a univariate scatterplot should be, and also provide beautiful excel templates in order to do so (as a supplemental document). But they did not include error bars. I recommend you use these templates since they are carefully designed to be easily used.
Excuse me, I forget to add the link to the paper
http://journals.plos.org/plosbiology/article?id=10.1371/journal.pbio.1002128
Dear Wulli,
in excel you can add computed (i.e. std deviation or std errors) or customised error bars to different type of graphs.
These Youtube videos show how to do that:
https://www.youtube.com/watch?v=N1xwu8eSk7k
https://www.youtube.com/watch?v=JeqCl_aD_8Y
Dear Luis, Ivan and John,
Thanks a ton, for the paper, links and your suggestions!! They solved my problem and are really helpful.
Best regards.
you may install RExcel
http://rcom.univie.ac.at/download.html
, then you can use R within Excel and you can make fancy plots in Excel, as those you want to make.
- Badges
- Science topic
- Similar topics
- Bioinformatics
- Bioinformatics and Computational Biology