Chart & Visualization Issues

Plot Date and Time Values in a Microsoft Access XY Scatter Chart

Elise WilliamsElise Williams Nov 22, 2026 868 views

Question details

The user needs to plot date and time values against numeric responses in an Access XY scatter chart.

Plot Date and Time Values in a Microsoft Access XY Scatter Chart
Product
Microsoft Access
Device & OS
not provided
Scenario
An Access chart uses a date/time field for the X-axis and numeric response values for the Y-axis.
Observed behavior
Time values may appear incorrectly, or the points may form a vertical line when the field type, series orientation, or axis scale is wrong.
Before you start

Identify the chart's source table or query and confirm which field contains the date and time and which contains the numeric responses. Check whether the chart is a classic chart or a newer Access chart, since their data settings differ.

Solution 1Recommended

Correct the Access chart's fields and series orientation

Use this method when date or time values plot incorrectly or points appear in a vertical line.

1
Check the source field

Open the source table in Design View and check that the date and time field has the Date/Time data type. Confirm that the response field contains numeric values.

2
Avoid the Time name

If the field is named Time, use a descriptive name such as ReadingTime, or open the source query in Design View and give the field an alias such as ReadingTime: [Time]. Update any affected references if you rename the table field.

3
Set the series orientation

Open the form or report in Design View and double-click a classic chart to edit it. In the chart's Data menu, select Series in Columns. Newer chart controls use different settings, so select the chart and check its Chart Settings pane instead.

4
Assign the chart values

In the chart's data settings or source query, use the date/time field for X values and the numeric response field for Y values. Make sure the chart type is XY Scatter.

5
Inspect the axis and data

Preview the form or report. If points still form a vertical line, edit the horizontal axis scale and check the source data for repeated X values, missing dates, or values outside the displayed range.

Correct the Access chart's fields and series orientation
Chart controls vary: Series in Columns applies to classic charts edited with Microsoft Graph. For newer charts, use the available field and series controls in Chart Settings.
Free Microsoft Office alternative

Create a Date and Time Scatter Chart in WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface and Excel format compatibility for easy migration. Export Access data to a spreadsheet to create a scatter chart in WPS; it does not fix or replace the Access chart.

  1. 1. Export the data: In Access, select the source table or query, then use External Data > Excel to export its records.
  2. 2. Open the spreadsheet: In WPS Spreadsheets, open the exported Excel file and check that the date/time and numeric values are in separate columns.
  3. 3. Insert a scatter chart: Select the date/time and response columns, then use Insert > Chart and choose an XY scatter chart. Check that the date/time column supplies the X values.
Plot date and time data against numeric values in a scatter chartOpen and save Microsoft Excel XLSX filesWork in a familiar spreadsheet interfaceUse a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why do the points form a vertical line in my Access scatter chart?

The X values may be identical, assigned incorrectly, or displayed on an unsuitable scale. Check the source query, the chart's X-value assignment, and the horizontal axis settings.

Can I use a field named Time in an Access chart?

You can reference it as [Time], but Time() is also a built-in Access function. To reduce ambiguity, give the field a descriptive name or use a query alias such as ReadingTime: [Time].

Where is Series in Columns in Access?

For a classic chart, open the form or report in Design View, double-click the chart, and look in the chart's Data menu for Series in Columns. Newer chart controls use the Chart Settings pane instead.

Does WPS Office repair an Access chart?

No. WPS can chart data exported from Access, but changes made in WPS do not repair the chart control in the Access database.