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

J

jo

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
Use text descriptors as Y axis units 1
Getting the graph style I want 4
Excel 2007: X-axis labeling 1
Scatter chart with categories on x-Axis 2
Constant % on X axis 2
How do I draw a graph in Excel 5
How do I specify X,Y axis and Series values in a line graph? 5

Top