Add a horizontal label by going into the Chart layout tab and selecting “Axis Titles.” 12. Double-click on one of the bars in the chart, which will open the “Format Data Series” box. Under Options, change the “Gap width” to be 0%.
When you, you can add axis titles to any horizontal, vertical, or depth axes in the chart. The titles will help the people who view the chart understand the data. You can't add axis titles to charts that don't have axes (like pie or doughnut charts).
Click anywhere in the chart you want to add axis titles to. Click the Chart Elements button next to the upper-right corner of the chart. To add primary horizontal and vertical axis titles, check the Axis Titles box.
To add depth or secondary axis titles, click the arrow next to Axis Titles, and then click More Options. Click each Axis Title box in the chart, and then type the text you want. To start a new line in the title, press Shift+Enter. Tip: To format the axis titles, right-click them, click Format Axis Title, and then pick the formatting options you want.
Link axis titles to text on the worksheet To use text on the worksheet for your axis titles, you link the axis titles to the worksheet cells that contain the text. Linked titles are automatically updated in the chart when you change the corresponding text on the worksheet. On the chart, click an Axis Title box. On the worksheet, click inside the formula bar, and then type an equal sign (=).
Select the worksheet cell that contains the text to use for the axis title and then press Enter.
![2011 2011](https://library.barnard.edu/sites/default/files/images/inline/slide55_0.jpg)
Tip. Excel automatically inserts a legend with default formatting at your selected location in the chart. You can then format the legend's font and change its location via the Legend Options panel. To access the Legend Options panel, start by clicking your chart to select it. Click the 'Charts' tab on the ribbon, click 'Chart Layout,' click the 'Legend' button, and then click 'Legend Options' to load a list of customizable options for your legend. Click the 'Font' tab to customize the font. Click the 'Placement' tab to change where the legend appears on the chart.