How to Fix Excel Chart Not Showing Newly Added Data Points
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.

- 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.
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.
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.
Right-click on the horizontal x-axis (the dates) of your chart and select 'Format Axis' from the context menu.
In the Format Axis pane that appears on the right, navigate to the 'Axis Options' section.
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).
Press Enter to apply the new maximum bound and verify that the chart updates to show the previously hidden data and shaded areas.

Re-insert the Stacked Area Chart
If adjusting the axis bounds does not work, creating a new chart from the complete data range can quickly resolve plot area glitches.
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. Open Your Workbook: Launch WPS Spreadsheet and open the document containing your chart.
- 2. Expand Data Range: Select the chart and drag the highlighted colored boxes in the spreadsheet grid to include your newly added rows.
- 3. Format the Axis: Double-click the x-axis to open the formatting pane on the right side of the screen.
- 4. Update Bounds: Navigate to Axis Options and modify the Maximum bounds to ensure all newly added dates are visible within the plot area.

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'.




