Then right click at the primary X axis (the bottom one) and select Format Axis.Ģ0. In Excel 2013, you just need to directly type 0 and 1 in the Minimum and Maximum text boxes, and check Axis value with 0 typed in the Format Axis pane.ġ9. Then check Axis value and type 0 into its text box in the Horizontal axis crosses section. Then in the Format Axis dialog, go to the Axis Options section, check the Fixed option behind the Minimum, and entering 0 in the following text box check the Fixed option behind the Maximum, and enter 1 in the following text box. Then right click at the primary Y axis (the left one), and select Format Axis from the context menu. In Excel 2013, you do not need to change the marker to circle.ġ7.
In Format Data Series dialog, click Marker Options tab, and check Built-in option, then select circle from the list of Type. Right click at the red markers, and select Format Data Series. Now you need to change the markers to circles. In Excel 2013, you need to click All Charts tab in the Change Chart Type dialog, and then click at the arrow of the Height series name, and select Scatter from the list. In the Change Chart Type dialog, click X Y (Scatter) section, and click Scatter with only markers. Click on the red series, and go to Design tab, and select Change Chart Type. In Excel 2013, click DESIGN > Add chart Element > Axes > Secondary Vertical.ġ2. Close the dialog and then go on to select the blue series, and click Layout > Axes > Secondary Vertical Axis > Show Default Axis. In Excel 2013, check Secondary Axis under Series Option section in the Format Data Series pane.ġ1. In the Series Options section, check Secondary Axis. Right click at first series (the blue one), and select Format Data Series from the context menu. Then click OK, you can see the bar chart become as follow:ĩ. Then in the popped out Paste Special dialog, check New series option in Add cell as section, check Columns in Values (Y) in section, and both check Series Names in First Row and Categories (X labels) in First Column checked boxes. Then click at the chart, and click Home > Paste > Paste Special. Then select the second and third column (Value Column and Height Column) data, and right click to select Copy from the context menu. If the legend exists, please delete it.ĥ. In Excel 2013, the legend is not added into the chart by default. Select the Legend in the chart, and press Delete key to delete it. Select the first and second columns (Label Column and Value Column) data, and click Insert > Bar > Clustered Bar.
Then in C2, type this formula =(ROWS($A$2:$A$12)-ROW()+ROW($A$2:$A$12)-0.5)/ROWS($A$2:$A$12), press Enter key and drag autofill handle to the range you need to apply this formula. Select the first cell and type Height into the column next to your data, here, I select C1. Height data provides the vertical coordinates for Y axis.ġ. To create a dot plot, you need a formula to calculate each data’s relative height data.