Instructional video on creating a dot plot of a categorical variable using excel (2016, but similar for older versions). companion website at peterst. How to create connected dot plots in excel by modifying a scatter chart.the data and the inspiration for this chart came from our world in data: ourwo.
File download: excel university yt x4rijm6fcjathis short excel video demonstrates how to create and format a dot plot, and also discusses why. Figure 1 – dot plot (step 1) step 1: highlight the first two rows of the data (column headings and one row of data) and select insert > charts|column chart and select the clustered column option. the result is shown in figure 1. step 2: we next click on the chart and so charting tools appears in the ribbon. now select design > data|select data. Add a second series to the xy scatter chart. next, right click on the graph, and choose select data. you can then click the plus button to add a series. choose the dairy girl values for the x values and spacing for the y values. adjust the axes. hopefully, you can start to see the dot plot taking shape. Select the data: choose the data set you want to visualize in the dot plot. ensure that the data is organized in a clear and understandable format within the excel spreadsheet. insert the dot plot: navigate to the "insert" tab in excel and choose the "scatter" chart type.
Comments are closed.