Amazing Add Horizontal Axis To Excel Chart
Check the box and the Axis will appear in the chart.
Add horizontal axis to excel chart. Select a chart to open Chart Tools. Select Secondary Axis for the data series you want to show. Change horizontal axis values.
Below are the steps to add a secondary axis to the chart manually. In the Select Data Source dialog box under Horizontal Category Axis Labels click the Edit button. Right click the chart and click Select Data from the right-clicking menu.
Click the axis title box on the chart and type the text. In the Select Data Source dialog box please click the Add button. Click anywhere in the chart.
Select the source data and then click the Insert Column Chart or Column Column on the Insert tab. This displays the Chart Tools adding the Design and Format tabs. Then check the tickbox for Axis Titles.
If you want to display the title only for one axis either horizontal or vertical click the arrow next to Axis Titles and clear one of the boxes. To format the axis title right-click it and select Format Axis Title from the context menu. In the Edit Series dialog box please specify the series name and series values exactly same as original series.
First off you have to click the chart and click the plus icon on the upper-right side. Select the data set Click the Insert tab. Select Data on the chart to change axis values.