![]() In Excel 2013 click the plus icon beside the chart click on the right-facing arrow beside Axes and check the Secondary Horizontal box. To do this we can create a fake data series that shows the minimum and maximum value.ĭifference between line graph and scatter plot excel. Go to the Inset tab Chats group click the Scatter chart icon and select the desired template.Ĭreate a scatter plot from the first data set by highlighting the data and using the insert chart scatter sequence.Īlso you will learn how to display different chart elements. To create a scatter plot with straight lines execute the following steps. Select two columns with numeric data including the column headers. Step 3 Click on the down arrow so that we will get a list of scatter chart as shown below.Ĭlick a scatter plot or drag one to the sheet.Ī scatter plot also called an xy graph or scatter diagram is a two dimensional chart that shows the relationship between. ![]() The X Y coordinates for each group are shown with each group possessing a unique color. ![]() The scatter plot for your first series will be placed on the worksheet. To download the file used in this video visit the following page.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |