To compare large numbers of time-independent data points. To visualize outliers, clusters, non-linear trends, and linear trends in a large set of data. To explore positive or negative trends in the variables. The appearance of the X and Y chart will be quite similar to a diagonal arrangement. To analyze if there is any correlation between two sets of quantifiable values. In the following scenarios, you should use a scatter plot instead of a line graph: In Excel, you can create a scatter plot graph to visualize and compare numeric values obtained from scientific and statistical analyses. The horizontal (X) axis represents one set of numerical data, and the vertical (Y) axis indicates another data set.īut, the Excel line graph visualizes all category data on the horizontal (X) axis and numerical values on the vertical (Y) axis. Both are similar except for the data representation along the horizontal (X) axis.Ī scatter chart consists of two value axes for quantitative data visualization.
![how to change axes of a scatter chart in excel 2007 how to change axes of a scatter chart in excel 2007](https://www.extendoffice.com/images/stories/doc-excel/axis-break/doc-axis-break-19.png)
![how to change axes of a scatter chart in excel 2007 how to change axes of a scatter chart in excel 2007](http://cameron.econ.ucdavis.edu/excel/twowayplot2.gif)
In Microsoft Excel, you may confuse whether an X-Y graph is a scatter plot or a line graph.
How to change axes of a scatter chart in excel 2007 how to#
I have demonstrated how to build dynamic data labels in a previous article if you are interested in using those in a chart. This means that you can build a dynamic chart and automatically change the labels depending on what is shown on the chart. Scatter Plot Excel-When You Should Use It The picture above shows a chart that has custom data labels, they are linked to specific cell values. Keep reading this data-based article to learn how. However, you may be wondering how to make a scatter plot in Excel.
![how to change axes of a scatter chart in excel 2007 how to change axes of a scatter chart in excel 2007](https://cdn.extendoffice.com/images/stories/doc-excel/display-text-in-Xaxis-of-scatter-chart/doc-display-text-in-Xaxis-of-scatter-chart-6.png)
When you need to visualize the relationship between two sets of quantitative data, Microsoft Excel makes it possible for you to create an X-Y scatter graph.įor regression analysis, scatter plot graphs are the most important data visualization tool.