Expand the Series subsection, and scroll down to find the checkboxes for Trendlines, Data labels, and Error bars. In the Chart editor dialog box, click on Customize to open a new menu. Select it, and your data will convert to an x-y graph. Open the dropdown menu for Chart type, and scroll down to find the Scatter chart option.

The Chart editor dialog box will appear on the right side of the screen. A box will appear and be automatically populated with a chart or graph reflecting the selected data. Press the Insert button near the top of the screen to open a dropdown menu. On Mac, hold the Command key while you click. For PCs, hold the Shift key to select multiple columns.

Select the two columns of numbers you want to compare by clicking on and selecting the column names. Here’s a step-by-step guide about how to make an x-y graph in Google Sheets. Google Sheets offers various chart-building tools, making it quick and easy to create eye-catching data visualizations. Gather data with Jotform and sync it to Google Sheets automatically with our free integration. This type of graph is critical for showing granular data in ways that other charts can’t, particularly among large sets of numbers. Each data point would represent the current salary and work experience of an individual. The y-axis might list salary ranges from $25,000 to $100,000. Understanding the basics of an x-y graphĪlso known as a scatter chart, an x-y graph plots a series of data points to illustrate the relationship between two sets of numbers.įor example, in an x-y graph about salary and number of years worked, the x-axis would list the number of years an employee has worked at a company. Before you get started building your own, here’s everything you need to know about how to make an x-y graph in Google Sheets. It allows users to create a variety of charts and graphs directly from the data they’ve meticulously documented. It’s also important to present your data in a way that’s visually pleasing. Data visualization is crucial for conveying information clearly and effectively. Numbers are important for understanding markets, customers, and performance, but let’s face it - staring at a data sheet isn’t necessarily exciting.

Google gantt chart maker