Making Publication-quality Bar Graphs in Excel

TL;DR

Learn how to create bar graphs in Excel, including adding mean and standard deviation, formatting the graph, and adding error bars.

Transcript

hello it's uh 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 uh Excel version 2010 on a PC but it's pretty much the same for most other versions of excel especially the ones on the college systems but here we have an example data set we got group a group b Group C and... Read More

Key Insights

• 🉐 Excel can be used to create basic bar graphs, but additional formatting is needed to make them visually appealing and suitable for publication.
• 👻 Calculating and adding the mean and standard deviation allows for better data representation and analysis.
• 🉐 Customizing the appearance of the graph, including bar width, colors, and borders, helps improve the overall presentation.
• 🤢 Adding error bars, specifically standard error bars, provides a way to visualize the variability in the data.
• 📈 Excel's built-in chart layouts and options make it easy to find a suitable style for the graph.
• 💁 Font size and number format adjustments can further enhance the readability and clarity of the graph.
• 👀 While Excel can create professional-looking graphs, specialized graphing software like GraphPad Prism may offer more advanced features and customization options.

Questions & Answers

Q: How can I add the mean and standard deviation to my bar graph in Excel?

To add the mean, use the "Average" formula and copy it down for each group. For the standard deviation, use the "stdev" shortcut. Copy the formula down as well to calculate for each group.

Q: How do I customize the appearance of my bar graph in Excel?

You can customize the graph by removing the legend and horizontal lines, labeling the axes, adjusting bar width, changing colors, and adding borders. Use the "Chart Layouts" option to find a suitable style for your graph.

Q: Can I add error bars to my bar graph in Excel?

Yes, you can add error bars by selecting the graph, going to the "Chart Tools" tab, clicking on "Layout," and then choosing "Error Bars." Select "More Error Bar Options" and specify the positive and negative error values based on your standard error data.

Q: How can I increase the font size and adjust the number format of my graph in Excel?

Double click on the axis labels to increase the font size. To adjust the number format, double click on the axis, go to "Number" and choose the desired format, such as zero decimal places.

Summary & Key Takeaways

• Dr. Clark demonstrates how to plot a bar graph in Excel using an example data set with groups and replicates.

• He explains how to calculate and add the mean and standard deviation to the graph.

• Dr. Clark shows how to customize the graph's appearance, including labeling axes, adjusting bar width, and changing colors.

• He also demonstrates how to add standard error bars to the graph.