how to set x-axis starting from number 0?

Y

Ye

Excel numbers x-axis from 1 by default. But I want to
number it from 0. Do you know how to do it?
 
J

Jerry W. Lewis

Use an "X-Y (Scatter)" chart instead of a "Line" chart.

The "Line" chart is misleadingly named. It has nothing to do with
whether you want a line or not. A "Line" chart would be more accurately
called a "category" chart, since the x-axis represents equally spaced
categories (labeled 1,2,3,... by default) instead of an arithmetic scale.

If you really want a non-arithmetic scale labeled with numbers starting
at zero, then supply your own labels in a range to the "Line" chart.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top