What is the difference between scatter plot and line graph

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.

On the Insert tab, in the Charts group, click Line. To reduce the size of the chart title, right-click the title, and then enter the size that you want in the Size box on the shortcut menu. On the chart, click the legend, or select it from a list of chart elements Layout tab, Current Selection group, Chart Elements box.

On the Layout tab, in the Labels group, click Legend , and then click the position that you want. To plot one of the data series along a secondary vertical axis, click the data series for Rainfall, or select it from a list of chart elements Layout tab, Current Selection group, Chart Elements box.

Reset your password if you forgot it. Solvers Solvers. Lessons Lessons. Answers archive Answers. Change the scale of your X axis. Keep in mind the X axis is always a value axis. Use specific math functions, especially logarithmic numbers, on your X axis.

In this case, you can easily transfer numbers into the logarithmic format on your X axis. Show your original worksheet data that has more than one set of values. Feel free to adjust the independent scales of the X and Y axes to reflect more details about your values. Indicate patterns on a large scale of data. In such case, it is very useful for illustrating the overall patterns of the data. Do not want to consider time factors when comparing large sets of data points.

The more data sets you insert in a scatter chart, the better comparison you can get. And check out the blog post on our eight best tutorials on Excel charts.

Create a chart from start to finish. Free training: Take the next steps in growing your Excel skills Lesson 2. Go beyond the basic chart type. No worries. Use sparklines to show data trends. Format column sparkline charts using the date axis and cell merging.

This month, we're announcing some top requested features like tracking changes in Excel and live transcriptions in Teams, as well as some soon-to-be-favorites like meeting recaps, turning Word documents in presentations, and more. Since we introduced Microsoft to individuals and families earlier this year, we have continued to deliver new innovations across our apps and services to help you and your family save time and stay connected.

Locate your loved ones and build better driving habits with Microsoft Family Safety Stay connected even…. And I know our customers feel it too.