BAILEY DEBARMORE
  • Home
  • Productivity
    • Blog
    • My Recs
  • EPI
    • EPICODE
    • #EpiWritingChallenge >
      • About the EWC
      • All Posts
  • Wellness
    • Health Blog
    • My Recs
  • Freebies

How to Make Publication Quality Graphs in Excel

9/16/2018

0 Comments

 
How to Make Publication Quality Graphs in MS Excel - EPICODE - Bailey DeBarmore
Learning to clean your data and run the appropriate statistical tests in your program of choice is challenge enough. When it comes to producing graphs for your posters and publications, it can be frustrating to learn how to code to get exactly the graph you want. 

Using Microsoft Excel to produce graphs can open up a whole new world for you. Easily organizing your data from columns to rows, adjusting categories and axes in real-time can streamline the entire process. 

While the default figures left much to be desired, this post will summarize several ways to strategically change the aesthetics to create publication quality graphics.​
For details on how to transform your Excel graphs from lackluster to publication-read, download the PDF below
download

summary

  1. Make sure your data is in the right format for inserting a chart
  2. Change font from default Calibri to Arial, and change all font from gray to black
  3. Add X- and Y-axes lines in black
  4. Add axis titles
  5. Change colors and patterns of graph for optimal design

Optional
  • Add secondary Y-axis if needed
  • Change units if needed

About the Author

Picture
Bailey DeBarmore is a doctoral student at the University of North Carolina at Chapel Hill studying epidemiology. Find her on Twitter@BaileyDeBarmore and blogging for the American Heart Association on the Early Career Voice blog. ​​
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Picture
    Picture

    Practical solutions for conducting great epidemiology methods. Transparency in code. Attitude of constant improvement.

    Appreciate my stuff?

    Picture

    Picture
    Picture
    Picture
    Picture

    Picture
    Picture

    All
    Bailey DeBarmore
    Data Visualization
    Excel
    IPW
    Paul Zivich
    P Values
    Python
    R
    Regression
    SAS
    Stata
    ZEpid


    Picture

    March 2021
    September 2020
    April 2019
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018


    RSS Feed

BLOGS

Work & Productivity
Health and Nutrition
EPICODE

About

About Bailey
CV and Resume
CONTACT

RD EXAM

Study Smarter Method
RD Exam Resources

FIND ME ON

Facebook
LinkedIn
Twitter
Google Scholar
Research Gate
Terms & Conditions | Privacy Policy | Disclaimers
Copyright Bailey DeBarmore © 2020
  • Home
  • Productivity
    • Blog
    • My Recs
  • EPI
    • EPICODE
    • #EpiWritingChallenge >
      • About the EWC
      • All Posts
  • Wellness
    • Health Blog
    • My Recs
  • Freebies