Cool Excel Chart Add X Axis Label

Right click the X axis in the chart and select the Format Axis from the right-clicking menu.

Excel chart add x axis label. An axis label is different from an axis title which you can add to describe whats shown on the axisAxis titles arent automatically shown in a chart. In the Select Data Source dialog box under Horizontal Category Axis Labels click Edit. In the opening dialog box check the Existing worksheet option and then select a cell in current worksheet and click the OK button.

2 In Excel 2013 clicking the Pivot Chart Pivot Chart in the Charts group on the Insert tab. In the Axis label range enter the cell references for the x-axis or use the mouse to select the range click OK. This displays the Chart Tools adding the Design and Format tabs.

In the Axis Labels dialog for Axis Label Range enter the data range for Code exclude the header the first row. You can add the secondary X axis or remove the secondary Y axis using the controls on the ribbon or on Excel 2013s plus sign icon next to the chart. Select the data you use and click Insert Insert Line Area Chart Line with Markers to select a.

To learn how to add them see Add or remove titles in a chartAlso horizontal axis labels in the chart above Qtr 1 Qtr 2 Qtr 3 and Qtr 4 are different from the legend labels below them East Asia Sales 2009 and East Asia Sales 2010. 1 In Excel 2007 and 2010 clicking the PivotTable PivotChart in the Tables group on the Insert Tab. In Excel 2013 click the icon to the top right of the chart click the right arrow next to Data Labels and choose More Options.

Click anywhere in the chart for which you want to display or hide axes. To add a chart title in Excel 2010 and earlier versions execute the following steps. In the dialog box under Legend Entry Series select the first series and click Edit.

Navigate to the Layout tab in Microsoft Excels toolbar. And you can do as follows. For example type Quarter 1Quarter 2Quarter 3Quarter 4.