Now, since we already have a decent title in cell B3, I'll use that in the chart. X values come from column C and the Y values come from column D. Here you can see there is one data series. Let's check Select Data to see how the chart is set up. When I click the mouse, Excel builds the chart. The first preview shows what we want - this chart shows markers only, plotted with height on the horizontal axis and weight on the vertical axis. Here I'll select all data for height and weight, then click the scatter icon next to recommended charts. When creating scatter charts, it's generally best to select only the X and Y values, to avoid confusing Excel. Let's create a scatter plot to show how height and weight are related. On this worksheet, we have the height and weight for 10 high school football players. A scatter chart has a horizontal and vertical axis, and both axes are value axes designed to plot numeric data. In this video, we'll look at how to create a scatter plot, sometimes called an XY scatter chart, in Excel.Ī scatter plot or scatter chart is a chart used to show the relationship between two quantitative variables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |