Forum Discussion

Georgi1925's avatar
Georgi1925
Copper Contributor
Jan 25, 2024

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, but the starting day in the diagram is always a Suturday.

Is it possible to change this day to Sunday or something else?

I tried changing the default setting of Windows, but it did not work.

I need a solution without VBA.

 

Thank you.

excel
    • Georgi1925's avatar
      Georgi1925
      Copper Contributor
      Jan 29, 2024
      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
      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Jan 29, 2024

        Georgi1925 

        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.

Resources