how to customize the x axis in scatter plot?

  • Thread starter Thread starter Meimei
  • Start date Start date
M

Meimei

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.
 
Do you mean you want a Line chart where the x-values are not treated as
numbers?
best wishes
 
Back
Top