How do I start the line graph at 0 on the x axis instead of 1?

G

Guest

When I type the data into the spreadsheet, it starts at 1, not 0. Then when I
make a graph, it puts the first y value at 1 on the x axis. Is there a way to
make my first y value start at x=0? I have microsoft Excel 2003
 
A

Andy Pope

Hi,

Sounds like you have a Line chart, which uses categorical x axis rather
than value, and use have not specified the x's. By default the point
index starts at 1.

First change the chart type to XY Scatter and then make sure you specify
the x values.

Cheers
Andy
 

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

Similar Threads

Make Y-axis values correspond to x- axis value 1
Constant % on X axis 2
How can I make a scatter plot graph with a category x-axis? 0
Excel 2007: X-axis labeling 1
How do I extend the X-axis in Excel2007 3
Moving X-axis in Excel Graph 1
X axis on Graph?? 1
Remove Bar Graph Axis Values 0

Top