Making Publication-quality graphs in Excel

TL;DR

Learn how to create and format bar graphs in Excel for scientific publications.

Transcript

hello it's dr. Clark here I'm just going to go through some very basic graph plotting in Excel here we've got an Excel spreadsheet I'm using Excel version 2010 or PC but it's pretty much the same for most other versions of Excel specially the ones on the college systems but here we have an example data set we call Group a group B group C Group D wi... Read More

Key Insights

• 🉐 The video teaches how to plot and format bar graphs in Excel, specifically for scientific publications.
• 🪜 Adding mean and standard deviation is crucial in representing data accurately.
• 🉐 Excel graphs can be customized by adjusting colors, bar width, line style, and removing unnecessary elements.
• 💋 The importance of choosing appropriate axis labels and tick marks is highlighted.
• 📈 Using graphing software like GraphPad Prism can provide more advanced and aesthetically pleasing graph options.
• 💁 Excel graphs may require some manual adjustments to achieve desired formats.

Questions & Answers

Q: How can I add the mean values to my data set in Excel?

To add mean values, use the average formula in Excel by highlighting the desired data range, then closing the bracket. Copy this formula to the other groups.

Q: How do you calculate the standard deviation in Excel?

Calculate the standard deviation by using the STDEV formula in Excel. Highlight the numbers and copy the formula to other groups.

Q: Can you remove the legend and horizontal lines in Excel graphs?

Yes, you can remove the legend and horizontal lines by selecting them and deleting them. This will create a cleaner graph.

Q: How can I customize the appearance of individual bars in Excel?

To customize individual bars, double click on the bar, go to Series Options, and adjust the fill color and border style according to your preferences.

Summary & Key Takeaways

• The video tutorial demonstrates how to plot a bar graph in Excel using a sample data set.

• The instructor explains the steps of adding mean and standard deviation to the data.

• The video provides instructions on formatting the graph to make it suitable for publication.