x-axis dates dont match up with the nodes on the line graph

C

changetires

Does anyone know why this is happening. My other graphs using the same
time and date on the X and percentage values on the Y are matching up
right where they should but for some reason this one sheet isnt letting
the X-axis match up to the correct values?

tks
Ed
 
J

Jon Peltier

Are you using line or XY charts?
If it's a line chart, is the axis treated as a category axis or a time scale
axis?
If it's a line chart, is the Axis Crosses Between Categories/Dates option
checked?

http://peltiertech.com/Excel/ChartsHowTo/CatVsValueAxis.html
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=190

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


"changetires" <[email protected]>
wrote in message
news:[email protected]...
 

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