how to customize the x axis in scatter plot?
 

I have two columns of data
A B
1 100
2 90
3 110
10 132
20 150
25 152
I used scatter plot to plot column B as Y value and column A as the X
value. The plot itself looks fine. However, the x axis label and major
ticks are shown at 0, 10, 20, 30, ...
What I want is for the x axis label and major ticks to be at 1, 2, 3,
10, 20, 25. In other words, I want to them to correspond to the value
in column A. I could not figure out how to do it. Is it doable in
Excel.

how to customize the x axis in scatter plot?
 

Do you mean you want a Line chart where the x-values are not treated as
numbers?
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Meimei" wrote in message
...
I have two columns of data
A B
1 100
2 90
3 110
10 132
20 150
25 152
I used scatter plot to plot column B as Y value and column A as the X
value. The plot itself looks fine. However, the x axis label and major
ticks are shown at 0, 10, 20, 30, ...
What I want is for the x axis label and major ticks to be at 1, 2, 3,
10, 20, 25. In other words, I want to them to correspond to the value
in column A. I could not figure out how to do it. Is it doable in
Excel.