How to Make an XY Graph in Google Sheets?

In the modern world, data is precious, particularly for understanding performance, consumers, and markets.

But let’s be honest: Calculating numbers is not fun or interesting. And because of this, it’s critical to investigate how to convey raw data compellingly and clearly.

XY Graphs are helpful in this situation. You can use the XY Chart template in Google Sheets to view your data and gain insights. However, customization will take a lot of time and effort because it is only a basic tool. But worry not. This guide will inform you how to make an XY Graph in Google Sheets.

Table of Content:

1. What is XY Graph?
2. When to Use an XY Graph?
3. What are the Pros of an XY Graph?
4. How to Make an XY Graph in Google Sheets?
5. How to Edit an XY Graph in Google Sheets?
6. Wrap Up

What is XY Graph?

There are occasionally connections between important measures in your data. And comprehending these connections can help you find insights to put into practice.

Many call center managers are keen on the correlation between the number of individuals working a shift and the typical answer time. You can utilize an XY Graph (Scatter plot) to draw out relationship insights from your data. This simple chart reveals relationships that tables and other visualization techniques, like bar charts, cannot show.

This chart uses dots to denote significant data points. The placement of each dot on the horizontal and vertical axis shows values for data points. ‘’Use the chart below to see how two variables in your data relate to one another.’’

When to Use an XY Graph?

You may use various graphs and charts to visualize your data and get insights. However, a wider range of elements, such as your objective and context, play a role in selecting the best.

See the examples below to learn the best uses for Google Sheets Graph X and Y.

• Utilize an XY Graph to Examine the Connections between Essential Data Variables.

You can examine the potential relationship between your data’s crucial parameters by plotting this chart to see whether it exists. Observing and illuminating correlations between two numerical variables is the primary purpose of scatter plots.

• Visualizing Causal Effect in Company Data

The ability to visualize causal-effect linkages in your business data using scatter plot charts is also a helpful skill. For example, lack of cleanliness and customer service are the leading causes of restaurant customer complaints.

The purpose of an XY Graph is to obtain causal-effect insights. It is simple to see how a factor, like customer returns, directly contributes to a problem that costs money.

• In circumstances where the Independent Variable has Numerous Values

This graph can investigate hidden connections between dependent and independent variables in your data. Use Google Sheets Graph X and Y to see the link between data points that logically go together: sales revenue and profits.

What are the Pros of an XY Graph?

• The XY Graph is crucial, especially if your objective is to find a link between two data points.
• This graph is frequently used to show nonlinear relationships in data.
• A Scatter Plot is simple to read and comprehend, even for non-technical audiences.
• An XY Graph can display the relationship between two variables in your data.
• The XY Graph makes the range of data flow clear. Additionally, the maximum and minimum points are easily identifiable.

As we previously stated, creating an XY Graph in Google Sheets need not be complicated. With advice gathered from data visualization specialists, we’ve got you covered. You shouldn’t miss this, so keep reading.

How to Make an XY Graph in Google Sheets?

You can’t easily reach some of the controls for modifying Google Sheets since they are too far away. And as a result, using Google Sheets XY Graph maker to visualize your data will take a lot of time.

So what’s the answer?

With a third-party add-on, you can make it the most reliable tool. There are many add-ons for Google Sheets for data visualization, but ChartExpo is the best we suggest.

ChartExpo achieves perfect marks across the board (in our checklist).

• Simplicity of use
• Cost of access
• The quality of charts produced
• Impact on your browser

Even better, ChartExpo does not require coding or programming knowledge, unlike other data visualization-based extensions.

How to install ChartExpo in Google Sheets?

1. You can download ChartExpo directly from the Google Sheets App. To get started, click on Extensions in the top toolbar.
2. In the menu that appears, go to Add-ons and press the option Get add-ons.
3. Search for ChartExpo in the bar and click the Charts, Graphs & Visualizations by ChartExpo when it appears in the results.
4. Press the Install button, you will have to accept some permissions and you may have to confirm your Google account.

There is another direct way to install ChartExpo by clicking on the below link as well for your desired tool.

How can you get started with the ChartExpo Extension for Google Sheets?

Suppose you have two online stores and you want to analyze sales, profit margin, & the number of orders. Here is the data below.

Stores	Items	Sales	Profit %	Number of Orders
Great Store	Grocery	3195	12	405
Great Store	Household & Pet Care	3588	30	382
Great Store	Health & Beauty	4491	32	343
Great Store	DIY & Furniture	3169	26	541
Great Store	Office Supplies	4970	13	567
Great Store	Sports & Leisure	3794	10	378
Great Store	Electronics	5953	26	326
Great Store	Entertainment	5634	31	342
One-Click Picks	Garments	5520	34	521
One-Click Picks	Cosmetics	3042	14	451
One-Click Picks	Toys	3940	27	503
One-Click Picks	Books	3630	25	533
One-Click Picks	Garden & Outdoor	4535	24	380
One-Click Picks	Cleaning supplies	3618	21	335

• To get started with ChartExpo, install ChartExpo in Google Sheets from this link.
• Go to Extensions > Charts, Graphs & Visualizations by ChartExpo > Open.

• To access your chart library, click the Add new chart button.

• Once ChartExpo is loaded, you will see a list of charts.

• Then, scroll through the numerous chart templates until you see the Scatter Plot.

• Choose the Metrics option after selecting the sheet that contains your data. Add the corresponding numbers (in our example, we’ll add the Sales, Profit %, and Number of orders).
• To add dimensional data, click the Dimensions button and enter the desired values (in our case, we’ll use Items and Stores).

• You can use simple steps to create a scatter plot in Google Sheets. The process is smooth and straightforward, thanks to ChartExpo.
• Click the Create Chart button to complete the quick procedure and generate a Scatter Plot for your data.
• Your example of an XY Graph should resemble this if you follow the preceding procedures (below).

How to Edit an XY Graph in Google Sheets?

Here are simple edits to accomplish on the XY Graph maker.

How to add Postfixes and prefixes?

Follow these easy procedures to add prefixes and postfixes, such as currency symbols:

• To edit the x-axis, select the pencil-shaped icon.
• Click the Label Text in the Axis Bottom Properties interface after it appears. Add the dollar sign.

• Choose “Apply All” from the menu.
• Click the pencil-shaped icon next to the y-axis to add a postfix.
• When the Axis Left Properties interface appears, select Label Text by clicking the button.
• When prompted, type your % in the Postfix.

How to add a legend?

• If you wish to add a legend to the XY Graph, click the pencil-shaped icon.
• When the Legend Properties box appears, enable the Show button.
• Click the Apply function to save the changes.

How to add a title

• Select the pencil-shaped icon next to the title placeholder.
• Once the Property window appears, type “Online Store Sales Analysis” in the Line 1 text box.
• Next, select Show from the menu and move the switch to the right (i.e., on position).
• Click the Apply button to keep the changes.
• Click the Save button to keep your adjustments in the XY Graph.

• Here is your final chart.

 Insights

• Here the Dot size is representing the number of orders.
• Garments and electronics have high sales, & profit margins. But Garments have high numbers of order. On the other hand, Electronics have low numbers of orders.
• Cosmetics and groceries have low sales and profit margins. But both items have the almost same number of orders.
• DIY & Furniture have low sales. But it has a high-profit margin and a number of orders.

FAQs:

How do you make an XY Graph?

To create XY Graph in a few clicks without any coding, follow these simple steps.

• Open the Google Sheets.
• Click Extensions > Charts, Graphs & Visualizations by ChartExpo > Open.
• To access the charts library, click the Add new chart button.
• Look for the Scatter Plot in the charts list.
• Select your data and click Create Chart button.
• You will get the XY Graph, which you can edit and customize.

How do you make a graph on Google Sheets?

The built-in XY Graph in Google Sheets needs much customization and modification because it is basic. To overcome the issue above, enhance Google Sheets with add-ons like ChartExpo to obtain illuminating and simple-to-understand Scatter Plot Charts.

Wrap Up

How to make an XY Graph in Google Sheets doesn’t have to be complicated. We have just discussed the process in detail above. We advise you to take your time and read the informative advice about how to create Google Sheets Graph X and Y quickly and easily.

Which program is the most effective for use with an XY Graph to visualize data? One of the most prevalent tools for visualizing data is Google Sheets. Furthermore, it includes a Scatter Plot, an easy-to-use Plot.

Because ChartExpo is one of the most reliable add-ons, we suggest using it to create XY Graph. Additionally, there are plenty of users worldwide. It is also incredibly user-friendly for anyone, regardless of their level of computer proficiency.