How to make graphs in Google Sheets for a research paper

This post answers a specific question: how do you create graphs in Google Sheets that meet the standards of an academic research paper? It is written for high school students who have collected data and need to present it clearly and correctly before submission. After reading, you will know which chart types suit which data, how to format each element for publication, and what reviewers commonly reject. When your paper is ready, the Princeton Journal of Pre-Collegiate Research accepts original student research across all disciplines.

How to make graphs in Google Sheets for a research paper

To make a graph in Google Sheets for a research paper, select your data range, click Insert, then Chart. Choose a chart type that matches your data structure: bar or column charts for categorical comparisons, line charts for trends over time, and scatter plots for correlations. Label every axis with the variable name and unit. Add a descriptive figure caption below the chart. Export as a PNG at 300 DPI or higher for publication.

The process breaks down into five stages: organising your data, selecting the correct chart type, formatting the chart to academic standards, writing a figure caption, and exporting the file correctly. Each stage has specific requirements that differ from what you would do for a class presentation or a school report.

Before you open Google Sheets, your data must be structured correctly. Each column should represent one variable. The first row should contain the variable name and, in parentheses, the unit of measurement. For example: Temperature (°C) or Response Rate (%). Blank rows or merged cells will cause Google Sheets to misread your data range and produce an incorrect chart.

Once your data is structured, select the full range including the header row. Click Insert, then Chart. Google Sheets will suggest a chart type automatically. In most cases, this suggestion is incorrect for academic purposes. Open the Chart Editor on the right side of the screen and select the chart type manually based on the guidance below.

For categorical data, such as survey responses grouped by demographic, use a bar chart with horizontal bars or a column chart with vertical bars. For data collected at regular time intervals, use a line chart. For two continuous variables where you are testing a relationship, use a scatter plot. Pie charts are rarely appropriate in academic research because they make proportional comparison difficult and cannot display statistical relationships.

Every axis must be labelled. Click on the chart, open the Chart Editor, go to Customize, then Chart and axis titles. Enter the axis label including the unit in parentheses. Set the font to a serif typeface such as Times New Roman or a clean sans-serif such as Arial, at 11 or 12 points. Remove the chart title from the chart itself. The figure caption placed below the chart serves that function in a research paper.

Write the figure caption in this format: Figure 1. A brief description of what the graph shows, including the variables, the sample, and the key finding. Place this caption directly below the image in your document, not inside the chart. Reviewers assess figure captions as part of the paper's clarity. A caption that simply restates the axis labels without explaining the finding is insufficient.

To export, right-click the chart and select Download, then PNG image. If your target journal specifies a minimum resolution, confirm the exported file meets that requirement before submission. For a detailed walkthrough of organising your dataset before charting, see this guide on how to use Excel and Google Sheets for research data.

What makes a research graph different from a class presentation chart?

The core difference is that a research graph must communicate a finding independently, without verbal explanation. A reviewer reading your paper will not hear you present. The graph must convey the pattern, the variables, and the scale without any ambiguity. This requires a level of precision that most students have not applied to charts before.

In a class presentation, a chart title like Survey Results is acceptable because the speaker provides context. In a research paper, that title communicates nothing. The figure caption must specify what was surveyed, who the respondents were, and what the chart reveals. According to the American Psychological Association's Publication Manual (7th edition), every figure must be interpretable without reference to the surrounding text.

Gridlines and background colour are also treated differently. Google Sheets applies a light grey background and horizontal gridlines by default. For academic publication, set the plot area background to white and reduce gridlines to a minimum. Major gridlines at round-number intervals are acceptable. Minor gridlines add visual noise without adding information and should be removed.

Colour choice matters for two reasons. First, many academic journals print in greyscale or are read on greyscale devices. A chart that uses only colour to distinguish data series will become unreadable. Use both colour and pattern, or colour and marker shape, to differentiate series. Second, approximately 8 percent of males have some form of colour vision deficiency, according to the National Eye Institute. Avoid red-green combinations as the sole distinguishing feature between data series.

If your paper includes more than one graph, maintain consistent formatting across all figures. Use the same font, the same axis label style, and the same colour scheme throughout. Inconsistency across figures signals to reviewers that the paper was assembled rather than carefully prepared. Before you submit, review published student research to understand the standard. You can browse published issues to see how figures are presented in accepted papers.

What are the most common graphing mistakes in high school research papers?

The four most common graphing mistakes in high school research papers are: using the wrong chart type for the data, omitting axis labels or units, writing uninformative figure captions, and exporting charts at low resolution. Each of these errors causes reviewers to question the student's understanding of their own data, which is a significant credibility problem regardless of how strong the underlying research is.

The first mistake is choosing a chart type based on appearance rather than data structure. Students frequently use pie charts for data that has more than five categories or for data where proportional comparison is not the point. A pie chart with eight slices is visually illegible and analytically weak. If you are comparing values across categories, use a bar chart. If you are showing how a value changes over time, use a line chart. The chart type is a methodological choice, not an aesthetic one.

The second mistake is labelling axes with variable names but omitting units. Writing Temperature on a y-axis without specifying Celsius or Fahrenheit makes the data uninterpretable. Every quantitative axis must include the unit of measurement. This is not a stylistic preference; it is a basic requirement of scientific communication.

The third mistake is writing figure captions that describe the graph rather than the finding. A caption that reads Bar chart showing test scores by group tells the reader nothing they cannot see. A caption that reads Figure 2. Mean test scores for the experimental group (n=34) were 14.3 points higher than for the control group (n=31), p=0.03 communicates the result. To understand what reviewers look for more broadly, read this analysis of what makes a research paper get rejected.

The fourth mistake is submitting charts exported at screen resolution, typically 72 DPI. At print size, these images appear pixelated and unprofessional. Always export at 300 DPI or above, or embed the chart in a document format that preserves vector quality.

How to make graphs in Google Sheets for a research paper, step by step

1. Structure your data correctly. Place each variable in its own column. Add the unit of measurement to the column header in parentheses. Remove blank rows and merged cells.

2. Select the full data range, including the header row. Click Insert, then Chart.

3. Choose the correct chart type manually. Do not accept the automatic suggestion without evaluating it. Use bar or column for categorical comparisons, line for time-series data, and scatter for correlations.

4. Label both axes with the variable name and unit. Set font to 11 or 12 point. Remove the default chart title from inside the chart.

5. Set the plot area background to white. Remove minor gridlines. If using multiple data series, distinguish them by both colour and pattern or marker shape.

6. Write a figure caption in your document below the chart. Include the figure number, a description of the variables and sample, and the key finding.

7. Export the chart as a PNG at 300 DPI or higher. Confirm the file is clear and correctly sized before inserting it into your manuscript.

8. Check consistency across all figures in the paper. Font, axis label style, and colour scheme should be identical in every chart.

If you are preparing a full manuscript for journal submission, review the submission guidelines before finalising your figures. Some journals specify figure file formats, resolution requirements, or caption placement conventions that differ from general practice.

PJPCR publishes original research across all academic disciplines. If your paper includes data visualisation and is ready for peer review, review the submission guidelines at princeton-jpcr.org/submit.

Frequently asked questions about making graphs in Google Sheets for a research paper

What is the correct chart type for survey data in a research paper?

For survey data, use a bar chart or column chart when comparing response frequencies across categories. Use a stacked bar chart when showing how subcategories contribute to a total. Avoid pie charts for more than four or five categories, as proportional differences become difficult to read accurately. The chart type should reflect the analytical question, not the visual preference.

How many graphs should a high school research paper include?

Most high school research papers include between two and five figures. Each figure should present a distinct finding that cannot be communicated as clearly in prose. According to the APA Publication Manual, figures should supplement the text, not repeat it. If the same information appears in both a table and a graph, remove one. Every figure must be referenced by number in the body of the paper.

Do I need special software to make publication-quality graphs, or can I use Google Sheets?

Google Sheets is sufficient for publication-quality graphs when used correctly. The key requirements are correct chart type selection, properly labelled axes with units, white background, minimal gridlines, and export at 300 DPI or higher. Specialised software such as R or Python produces more precise output, but Google Sheets meets the technical requirements of most student research journals when formatted carefully.

What makes a graph in a research paper publishable rather than just acceptable?

A publishable graph communicates a finding independently, without requiring the reader to consult the surrounding text. It uses the correct chart type for the data structure, labels every axis with the variable name and unit, distinguishes data series by both colour and shape, and includes a figure caption that states the key result. Reviewers assess figures as evidence of the author's understanding of their own data. A poorly formatted graph raises questions about the analysis itself.

Does PJPCR have specific figure formatting requirements for submitted papers?

Yes. The peer review process at PJPCR evaluates figures as part of the overall assessment of clarity and methodological rigour. Submitted papers should follow standard academic figure conventions: labelled axes with units, descriptive captions placed below each figure, and consistent formatting across all figures in the manuscript. Detailed requirements are available in the submission guidelines.

Conclusion

Making graphs in Google Sheets for a research paper requires three things: choosing the chart type that matches your data structure, formatting every element to academic standards including labelled axes, white backgrounds, and accessible colour choices, and writing figure captions that communicate findings rather than simply describing the chart. These are not cosmetic decisions. Reviewers treat figures as evidence of analytical clarity, and poorly formatted graphs are one of the most common reasons otherwise strong papers receive revision requests.

Apply the eight-step process in this post before finalising your manuscript. Check that every figure is consistent in font, style, and caption format. Export at 300 DPI. If you are preparing a paper for submission and want to see how figures appear in accepted student research, you can also explore the high school research paper example published on this site.

If your research is ready for peer review, submit it to PJPCR at princeton-jpcr.org/submit.