Line chart going up
1. Right click the X axis in the chart, and select the Format Axis from the right-clicking menu. 2. Go ahead based on your Microsoft Excel's version: (1) In Excel 2013's Format Axis pane, expand the Labels on the Axis Options tab, In a line chart, Excel lists the X axis labels in the same order as in the worksheet, and the origin is at the bottom left of the chart. Same with a column chart. Note in the column chart that the order that series are clustered is also the same order as in the worksheet. Now let’s make a problematic bar chart.