How To Create a Dot Plot in Excel

office 2010 support ― A Dot Plot or Dot Chart is one of the most simple types of plots and they are very easy to create in Excel without having to use a Chart object. The trick is to use the REPT() function to display the dot plot either horizontally or vertically. I will explain how this is done and you can download the Dot Plot Example file to see how I created the dot plots on this page. Horizontal Dot PlotI like board games. The example dot plot below shows the number of times out of 50 that I rolled a 1-6[...]