These charts are useful to show the relationships among the numeric values in several data series, and they can plot two groups of numbers as one series of xy coordinates. Line charts can display continuous data over time, set against a common scale, and are therefore ideal for showing trends in data at equal intervals or over time.
In a line chart, category data is distributed evenly along the horizontal axis, and all value data is distributed evenly along the vertical axis. As a general rule, use a line chart if your data has non-numeric x values — for numeric x values, it is usually better to use a scatter chart.
Change the scale of the horizontal axis Because the horizontal axis of a scatter chart is a value axis, more scaling options are available. Use a logarithmic scale on the horizontal axis You can turn the horizontal axis into a logarithmic scale.
Display worksheet data that includes pairs or grouped sets of values In a scatter chart, you can adjust the independent scales of the axes to reveal more information about the grouped values. Show patterns in large sets of data Scatter charts are useful for illustrating the patterns in the data, for example by showing linear or non-linear trends, clusters, and outliers. Compare large numbers of data points without regard to time The more data that you include in a scatter chart, the better the comparisons that you can make.
Use text labels along the horizontal axis These text labels can represent evenly spaced values such as months, quarters, or fiscal years. Use a small number of numerical labels along the horizontal axis If you use a few, evenly spaced numerical labels that represent a time interval, such as years, you can use a line chart.
Use a time scale along the horizontal axis If you want to display dates in chronological order at specific intervals or base units, such as the number of days, months, or years, even if the dates on the worksheet are not in order or in the same base units, use a line chart.
Note: The following procedure applies to Office and newer versions. Office steps? So, how did we create this scatter chart? The following procedure will help you create a scatter chart with similar results. For this chart, we used the example worksheet data. You can copy this data to your worksheet, or you can use your own data. Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data you want to plot in a scatter chart.
Tip: You can rest the mouse on any chart type to see its name. Click the chart area of the chart to display the Design and Format tabs. To change the font size of the chart title, right-click the title, click Font , and then enter the size that you want in the Size box. Click OK. For more title formatting options, on the Format tab, in the Chart Elements box, select the title from the list, and then click Format Selection.
A Format Title pane will appear. Click the plot area of the chart, or on the Format tab, in the Chart Elements box, select Plot Area from the list of chart elements. On the Format tab, in the Shape Styles group, click the More button , and then click the effect that you want to use.
Click the chart area of the chart, or on the Format tab, in the Chart Elements box, select Chart Area from the list of chart elements. If you want to use theme colors that are different from the default theme that is applied to your workbook, do the following:. On the Page Layout tab, in the Themes group, click Themes. So, how did we create this line chart?
The following procedure will help you create a line chart with similar results. Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data that you want to plot into a line chart. To plot one of the data series along a secondary vertical axis, click the data series, or select it from a list of chart elements on the Format tab, in the Current Selection group, click Chart Elements.
The Format Data Series task pane appears. Click the plot area of the chart, or select it from a list of chart elements Format tab, Current Selection group, Chart Elements box. Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data that you want to plot into a scatter chart. On the Insert tab, in the Charts group, click Scatter. On the Design tab, in the Chart Styles group, click the chart style that you want to use.
On the Layout tab, click Chart Title and then select a location for the title from the drop-down list. To reduce the size of the chart title, right-click the title, and then enter the size that you want in the Font Size box on the shortcut menu.
On the Layout tab, in the Labels group, click Axis Titles , and then do the following:. To add a vertical axis title, click Primary Vertical Axis Title , and then click the type of vertical axis title that you want. For our scatter chart, we typed Daily Rainfall in the horizontal axis title, and Particulate level in the vertical axis title.
Click the plot area of the chart, or select Plot Area from a list of chart elements Layout tab, Current Selection group, Chart Elements box. Here are some of the possible modifications you can make:. When you create a scatter plot in Microsoft Excel, you have the freedom to customize almost every element of it.
You can modify sections like axis titles, chart titles, chart colors, legends, and even hide the gridlines. Microsoft Excel also offers professional scatter chart templates. This is how you can check those out:. You can label the data points in the X and Y chart in Microsoft Excel by following these steps:.
You can add a line of best fit or a Trendline in your scatter chart to visualize the relationship between variables. To visualize the mathematical relationship between the data variables, activate the equation display on the scatter plot graph.
X and Y chart scatter graph can visualize three types of correlation between the variables in the data sets for meaningful data presentation. These correlations are as follows:. Microsoft Excel is a robust application that allows you to create the next-generation scatter plot graph.
Having learned how to create a scatterplot in Excel, you can also create smart charts in the program that update automatically. Self-updating Excel charts are huge timesavers. Use these steps to add new data and watch them automatically show up in a chart. Tamal is a freelance writer at MakeUseOf.
After gaining substantial experience in technology, finance, and business processes in his previous job in an IT consulting company, he adopted writing as a full-time profession 3 years ago. Related: How to Make a Chart in Excel In Excel, you can create a scatter plot graph to visualize and compare numeric values obtained from scientific and statistical analyses. In the following scenarios, you should use a scatter plot instead of a line graph: To analyze if there is any correlation between two sets of quantifiable values.
Select the two columns of data that you want to plot, then click the "Insert" tab on the ribbon menu. Click "Insert Line or Area Chart. Highlight the columns or rows with the data to include in the scatter plot. Click the chart that pops up to see the design and formatting options. Click the "Design" tab. Click the chart title area and input the title you want for your chart.
These instructions apply to Excel but also function similarly for Excel The chart features are the same between the two, but the main start screen has been updated for Excel
0コメント