![]() The best way to organize your data for a scatter plot is to place the independent variable in the left column and the dependent in the right. Choose “Primary Vertical” to add a vertical axis title.Name your horizontal axis under “Primary Horizontal.”.Now it’s time to name your axes so that anyone can understand the displayed data: Select the “Insert Scatter (X, Y) or Bubble Chart” option.Open the worksheet containing the data you want to plot.Best of all, you can create it in five simple steps. How to Plot Multiple Lines in a Scatter ChartĪ scatter chart is a beneficial and versatile chart type. Showing trends over time or at equal intervals.Displaying continuous data over time against a common scale.Plotting two groups of numbers to display a series of XY coordinates.Īs for the line chart, it’s best to use it for:.Showing the relationship between the numerical values in various data series.Displaying and comparing numerical values in statistical and scientific data.With this in mind, you should use scatter charts for: The vertical axis is the only value axis in a line chart, whereas the horizontal axis shows the data categories. In contrast, a line chart displays separate data points equally distributed along the horizontal axis. In fact, both axes show sets of numerical data and points of their intersection, thus combining the values into single data points. A scatter chart will never display categories on the horizontal axis, only numerical values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |