#EXCEL ADD AXIS TITLES HOW TO#
#EXCEL ADD AXIS TITLES FREE#

If you’re looking for help with a particular graph, take a look at how to create and customize a waterfall chart or a funnel chart in Microsoft Excel. In Excel on Windows, you can also click the Chart Elements icon and uncheck the box for Axis Titles to remove them both. If you want to keep one title, use the arrow next to Axis Titles and mark the one you want. Click the Add Chart Element drop-down arrow, move your cursor to Axis Titles, and deselect “Primary Horizontal,” “Primary Vertical,” or both. Select the chart and go to the Chart Design tab. If you decide later to remove one or both axis titles, it’s just as easy as adding them. RELATED: How to Create a Geographical Map Chart in Microsoft Excel Remove Axis Titles From a Chart You can then do things like change the font color or transparency, use a 3-D format, or change the text direction. Then use the tabs for Text Fill & Outline, Text Effects, and Text box. To customize the font, select Text Options at the top of the sidebar. You can do things like change the fill or border, add a shadow or glow, or adjust the alignment. Then use the three tabs directly below it for Fill & Line, Effects, and Size & Properties to make your adjustments. You can either right-click a title and select “Format Axis Title” or double-click one of the titles.Īt the top of the sidebar, make sure you see Title Options.

To take your customization a bit further, start by opening the Format Axis Title sidebar. Use the drop-down arrows next to any of these options to apply a theme, use a gradient or texture, or choose a border style and color. You’ll see options for Style, Fill, and Outline. And you have a few different ways to go about it.įirst, right-click an axis title to display the floating toolbar. You can customize both the axis title boxes and the text within those boxes. RELATED: How to Create a Combo Chart in Excel Customize the Axis Titles on a Chart Select the text box containing the default title and add your own. When the axis title you select appears on the chart, it has a default name of Axis Title. Check the box for Axis Titles, click the arrow to the right, then check the boxes for the horizontal, vertical, or both titles. If you’re using Excel on Windows, you can also use the Chart Elements icon on the right of the chart. In the pop-out menu, select “Primary Horizontal,” “Primary Vertical,” or both. Click the Add Chart Element drop-down arrow and move your cursor to Axis Titles. Select your chart and then head to the Chart Design tab that displays. If you want to make sure your chart is clear to those viewing it, you can add vertical or horizontal axis titles and customize those too. Type the title for the spreadsheet anywhere in the new row.

#EXCEL ADD AXIS TITLES FREE#

Select Entire Row and click OK to add a row of free space. First, right-click anywhere inside cell A1 (the first cell at the top left of your spreadsheet), and choose Insert. There are plenty of ways to customize a chart you create in Excel. To add an always-visible title, you can place it in the top row of your spreadsheet.

Excel add axis titles