Question: how to do x axis in excel?
Answer: Click anywhere in the chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs.
On the Format tab, in the Current Selection group, click the arrow in the Chart Elements box, and then click the axis that you want to select.