Change the Starting Date on an Excel XY Scatter Chart Axis
Question details
Set the first displayed date and control the automatic date range on an XY scatter chart without using VBA.
- Product
- Microsoft Excel XY Scatter Chart
- Device & OS
- not provided
- Scenario
- The user wants a scatter chart X-axis to begin on a specific date and update appropriately as source data changes.
- Observed behavior
- An XY scatter chart treats dates as numeric values, so the first visible date is determined by the X-axis minimum bound rather than regional calendar settings.
Make sure the X-axis source cells contain real Excel dates, not text values. Select the chart and confirm that it is an XY (Scatter) chart before changing axis bounds.
Set the X-Axis Minimum Bound to the Required Starting Date
Use this method when you need the scatter chart to start at one specific date.
XY scatter charts use a value axis for dates. Therefore, the first visible date is controlled by the Minimum bound of the horizontal axis.
Click the XY scatter chart, then click the horizontal X-axis that displays the dates.
Right-click the X-axis and select Format Axis from the context menu.
In Axis Options, find Bounds and enter the date you want as the Minimum value. If the field accepts a numeric value only, enter the Excel date serial number for that date.
In the Format Axis pane, open Number and choose a Date format so the axis labels display as readable dates.
Use an Excel Table or Dynamic Source Range for Automatic Chart Updates
Use this method when new dated records are added regularly and the chart range should expand automatically.
Set a Starting Date for a Scatter Chart Axis in WPS Spreadsheet
WPS Spreadsheet lets you create XY scatter charts, format the numeric date axis, and set a minimum axis value to control the first visible date. You can also use table-style source data to keep chart data organized as records are added.
- 1. Create or select the scatter chart: Open the worksheet in WPS Spreadsheet, select the chart, or choose Insert > Chart > Scatter to create an XY scatter chart.
- 2. Select the horizontal axis: Click the horizontal date axis in the chart to select the X-axis.
- 3. Open the axis settings: Right-click the selected axis and choose Format Axis.
- 4. Enter the starting date bound: Under Axis Options, set the Minimum bound to the required date value, then choose a Date format under Number if needed.
Frequently Asked Questions
Why does my XY scatter chart not start at the first date in my worksheet?
An XY scatter chart uses a numeric value axis, and its visible start is controlled by the X-axis Minimum bound. Right-click the X-axis, choose Format Axis, and check Bounds > Minimum.
Can I type a date directly into the Minimum bound for a scatter chart?
In many Excel versions, you can enter a recognized date directly. If the field requires a number, enter the Excel serial number that represents the date instead.
Do Windows regional date settings change the start of an XY scatter chart axis?
No. Regional settings can affect how a date label is displayed, but the first date on an XY scatter chart is determined by the axis minimum value.
How can I make an XY scatter chart include new dates automatically?
Convert the source range to an Excel Table through Insert > Table, then ensure the chart series references the table columns. New rows added to the table can then be included automatically.
Should I use a line chart instead of an XY scatter chart for dates?
Use a line chart when each date should be treated as an evenly spaced category. Use an XY scatter chart when spacing between dates must reflect the actual time intervals.
