Show Values I want to present in Chart x-axis

[cfkorea]

I need some help

I made some line chart in excel sheet

and I wanted to show only specific values on x-axis.

but it was not easy.

 

[ExcelTactics]

Usually, the x-axis is defined by the range of data. It automatically sizes to fit the biggest data point you have in your chart. You can change the limits by double-clicking the axis and setting the "Minimum" and "Maximum" values, but this will just adjust the range and not the points on the axis shown.

On the other hand, you can display the actual points of data on the line chart by selecting the Layout tab under Chart Tools, and clicking "Data Labels". This will show the values next to the points on the line.

 

[cfkorea]

then is there no method to show specific values on x-axis?

 

[ExcelTactics]

You could rig it but it wouldn't be linear (there wouldn't be proportional space between values). It would look like this:

See how the numbers aren't in order and they aren't spaced properly? If this is good enough, you can make your X-Axis "Text" format instead of number format, and this will be the result.

 

[cfkorea]

thank you for replying and your time.

but I wonder, for example, how can I delete 84 in x - axis, and keep the line chart same.

 

[ExcelTactics]

Just delete the 84. The chart will show the blank.

 

[cfkorea]

wow.. it works!!
thank you!