Powerful graphing, data analysis & curve fitting software. Over 25 different plot types. Customize the entire plot with easy, precise controls. Export publication-quality images.
- 25+ Different Plot Types
Starting at $175. Free Demo.
Scientific Graphing Software
- Pricing
Learn More About-Pricing of
Synergy Software
- Request a Quote
Robust Graphing/Data Analysis
Starting at $175. Free Demo.
- Request Quotation
Request Quotation With
Synergy-Call Us Today!
- Maintenance Updates
Check Out Our Maintenance
Updates-At Synergy Software Today.
- Free Trial
Free Trial on KaleidaGraph-For Mac
& Windows
- 25+ Different Plot Types
Search results
People also ask
How do I use a scatter chart in Excel?
What is a scatter graph?
How to make a scatter chart?
What is a scatter plot in Excel?
What is a scatter graph XY?
How do I change a scatter plot in Excel?
Jun 15, 2024 · How to Make a Scatter Chart in Excel. Select your data range. Go to the Insert tab. Click the drop-down for Insert Scatter (X, Y or Bubble Chart icon under Charts group. Choose Scatter. This command will insert a scatter chart based on the selected data range.
Use a scatter plot (XY chart) to show scientific XY data. Scatter plots are often used to find out if there's a relationship between variables X and Y.
A scatter plot or an XY graph is a type of graph used to display and analyze the relationship between two different variables. The horizontal (x-axis) and vertical (y-axis) axes represent numeric data in a scatter plot.
- Create a Scatter Plot
- Format Your Scatter Plot
- The Best Tech Newsletter Around
To create a scatter plot, open your Excel spreadsheet that contains the two data sets, and then highlight the data you want to add to the scatter plot.
Once highlighted, go to the "Insert" tab and then click the "Insert Scatter (X, Y) or Bubble Chart" in the "Charts" group. A drop-down menu will appear. Here, select the scatter plot style you'd like to use.
Once selected, the scatter plot will be inserted into the spreadsheet.
The data from our Value 1 column appears on the x-axis, and Value 2 on the y-axis.
If you need the scatter plot to match a specific style, you can change its design and format. To do so, click the scatter plot to select it and two new tabs will appear: Chart Design and Format.
In the Chart Design tab, you'll find options to let you change the chart layout and style, switch the row and column of data, and completely change the chart type if you happened to choose the wrong one initially. For example, if you want to change the chart style to a predefined style, select a style you like in the "Chart Styles" group.
Once selected, the change will happen automatically.
In the Format tab, you can change the fill, outline, and effects of the chart. For example, you can apply a glow effect around the graph. To do so, click "Shape Effects" in the Shape Styles group.
Hover your cursor over "Glow" and then select an option from the Glow Variations group in the sub-menu. We'll select the third orange option in this example.
The effect will be applied once selected.
By subscribing, you agree to our Privacy Policy and may receive occasional deal communications; you can unsubscribe anytime.
Share Share Share Share Share
Copy
Email
Share
Share Share Share Share Share
In this tutorial, I will show you how to make a scatter plot in Excel, the different types of scatter plots, and how to customize these charts. This Tutorial Covers: Toggle
Oct 4, 2024 · Are you wondering how to make a scatter plot in Excel? Follow along with this thorough tutorial to learn this must-have data visualization skill. A scatter plot helps you to show the relationship between two sets of numerical or quantitative analysis values.
Mar 16, 2023 · A scatter plot (also called an XY graph, or scatter diagram) is a two-dimensional chart that shows the relationship between two variables. In a scatter graph, both horizontal and vertical axes are value axes that plot numeric data.
