Chart & Visualization Issues

How to Fix Excel Chart Not Showing Newly Added Data Points

Aamir Naveed AkramAamir Naveed Akram Nov 4, 2026 869 views

Question details

The user needs to make a stacked area chart display newly added data points and dates, which are currently appearing outside the plot area and lacking shaded areas.

How to Fix an Excel Chart Not Showing Newly Added Data Points
Product
Excel
Device & OS
Mac
Scenario
Expanding the data range of an existing stacked area chart to include newly added rows of date-based data.
Observed behavior
The newly added dates appear outside the plot area, and the chart fails to display the corresponding shaded areas for the new data points.
Before you start

Ensure that the newly added data rows are formatted identically to the original data (e.g., dates are formatted as dates, not text) before modifying the chart settings.

Solution 1Recommended

Adjust the Horizontal (X-Axis) Maximum Bounds

Manually updating the axis bounds ensures that the newest dates fall within the visible plot area.

When an axis maximum limit is manually set in Excel, newly added data points that exceed this limit will not be plotted properly. Adjusting the bounds extends the visible area of the chart.

1
Format the X-Axis

Right-click on the horizontal x-axis (the dates) of your chart and select 'Format Axis' from the context menu.

2
Locate Axis Options

In the Format Axis pane that appears on the right, navigate to the 'Axis Options' section.

3
Adjust Maximum Bound

Under the 'Bounds' heading, look at the 'Maximum' value setting. Change this value to include your newest data point (for example, extend the date to accommodate the newly added rows).

4
Apply Changes

Press Enter to apply the new maximum bound and verify that the chart updates to show the previously hidden data and shaded areas.

Adjust the Horizontal (X-Axis) Maximum Bounds
Auto Bounds: If you frequently add new data, you can click 'Reset' next to the Maximum bound to change it back to 'Auto'. This allows Excel to update the axis boundaries automatically as your data grows.
Powerful Spreadsheet Alternative

Create and Manage Charts Easily with WPS Spreadsheet

WPS Office provides a highly compatible, intuitive spreadsheet application where adjusting chart data ranges and axis bounds is completely seamless. It fully supports Microsoft Excel file formats and offers advanced, easy-to-use visualization tools for free.

  1. 1. Open Your Workbook: Launch WPS Spreadsheet and open the document containing your chart.
  2. 2. Expand Data Range: Select the chart and drag the highlighted colored boxes in the spreadsheet grid to include your newly added rows.
  3. 3. Format the Axis: Double-click the x-axis to open the formatting pane on the right side of the screen.
  4. 4. Update Bounds: Navigate to Axis Options and modify the Maximum bounds to ensure all newly added dates are visible within the plot area.
Fully compatible with Microsoft Excel (.xlsx) formatsIntuitive chart formatting pane for quick axis adjustmentsLightweight application with fast performance on Mac and WindowsFree alternative with advanced charting capabilities
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel chart stop updating when I add new data rows?

This usually happens because the chart's data range is static or the axis limits have been manually fixed. Converting your raw data into an official Excel Table can help charts update automatically when new rows are added.

How do I convert my data into a Table for automatic chart updates?

Select your entire data range and press Ctrl+T (or Cmd+T on Mac). Once your data is formatted as a Table, any chart referencing it will automatically expand its range to include newly added rows.

What should I do if my dates show as serial numbers on the chart axis?

Double-click the axis to open the Format Axis pane. Scroll down to the 'Number' section and change the Category dropdown from 'General' or 'Number' to 'Date'.