ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   x-axis dates dont match up with the nodes on the line graph (https://www.excelbanter.com/charts-charting-excel/104416-x-axis-dates-dont-match-up-nodes-line-graph.html)

changetires

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

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


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=570496


Jon Peltier

x-axis dates dont match up with the nodes on the line graph
 
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/ChartsH...ValueAxis.html
http://pubs.logicalexpressions.com/P...cle.asp?ID=190

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


"changetires"
wrote in message
...

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


--
changetires





All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com