Measure the length: Hold a tape-measure or a measuring stick along the longest inner side of the box. Press the tip of the measure into one corner of the box, and stretch the tape along the length of the long side to the adjacent corner.
To show text instead of the number labels on the X axis, you need to add an additional series with the values 1 to 5. Add this series to the chart (copy the cells with the numbers 1 to 5, select the chart, use paste special and hit OK). Format the new series and change the chart type to XY Scatter. Then edit the source data for that series and select the Y axis values, which should all be zero. Now the data points are aligned on the x axis. Add data labels to this series, below the data markers. Edit each data label, click the Formula bar, hit the = sign and click the cell with the desired text.
Step 1: Right click the X axis in the chart, and select the Format Axis from the right-clicking menu. Step 2: Go ahead based on your Microsoft Excel's version: (1) In Excel 2013's Format Axis pane, expand the Labels on the Axis Options tab, click the Label Position box and select Low from the drop down list;