Forum Discussion
First day on the X-axis alway saturday
I made a xy scatter chart in Excel. On the x-axis I have date and on the y-axis a number. I need an automatic set of the range for the x-axis. When I change my data for the x-axis, the range changes...
Have you tried using a line chart instead?
- Within line chart it works indeed, but I need error bars for the dates and they do not work in the line chart. This is why I switched to the scatter chart
It looks like start date in scatter is automatically set as
=FirstDate - MOD(FirstDate,MajorUnit)Thus it's not always Saturday, depends on your scale.
Not sure such behaviour could be changed without VBA, at least I didn't see the way.
- It makes sence. Thank you
