You can also create a new set of data to populate the labels. You will add corresponding data in the same table to create the label. The procedure is a little different from the previous versions of Excel 2016. Often there is a need to change the data labels in your Excel 2016 graph. On the Home tab, click the Borders and Shading drop down (in the Paragraph group) and select Borders and Shading. Change Horizontal Axis Values in Excel 2016. This feature's a bit harder to find in 20. (It might take a few seconds for all the lines to load.) Just double-click a line to insert it-that's all there is to it.
Choose Borders and Shading from the Format menu and click the Horizontal Line button at the bottom of the resulting dialog box. Horizontal Line feature, artistic linesThose lines are certainly functional, but Word can draw lines that are a step (or two or three) up from the basic lines shown above. On the AutoFormat As You Type tab, uncheck Border Lines in the Apply Click AutoCorrect Options in the AutoCorrect Options section. In Word 2010, click the File tab, click Options (under Help) and then click Proofing in the left pane. In Word 2007 click the Office button and then click Word Options.
