Problems with x axis not lineup

[mike]

Hello,
Does anyone know where I can find some info on the web why a line chart
will not lineup to the y axis.
thanks in advance

 

[Nicky]

Hi,
Its not clear what you're trying to achieve, but if your problem i
that you want the series line to start on the Y axis, try this:

select the x axis, click Format, Selected Axis, click the Scale tab
and uncheck the 'Value (Y) axis crosses between categories ' bo

 

[Jon Peltier]

Mike -

Perhaps you need an XY Scatter chart? Right click on the chart, choose
Chart Type from the pop up menu, and choose one of the scatter
varieties. The names are misleading: you can connect the points in a
scatter chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[mike]

Thanks,
Perfect that did the trick.
Nicky > < wrote in message ...