Formatting Issues

How to Add More X-Axis Categories to a PowerPoint Chart on Mac

Phi Hung VoPhi Hung Vo Nov 2, 2026 870 views

Question details

The user needs to add new categories, such as new weeks or times, to the X-axis of an existing PowerPoint chart on a Mac.

How to Add More X-Axis Categories to a PowerPoint Chart on Mac
Product
PowerPoint
Device & OS
Mac
Scenario
Updating a presentation by inserting new data points into an existing chart.
Observed behavior
Newly entered data rows or columns in the embedded worksheet do not automatically appear on the chart's X-axis because the defined data range has not expanded to include them.
Before you start

Ensure you have the presentation saved. If your chart is linked to an external Excel file rather than an embedded worksheet, you will need to open and modify that specific external file directly.

Solution 1Recommended

Extend the Data Range Using Edit Data

This is the most common and direct method for charts created natively in PowerPoint using the 'Insert Chart' feature.

When you create a chart directly in PowerPoint, it generates an embedded Excel worksheet. Modifying the data requires you to open this embedded sheet and manually adjust the highlighted selection box to encompass any new categories.

1
Select the chart

Click on the chart in your PowerPoint slide to select it and reveal the Chart Design tab.

2
Open the data worksheet

Right-click the chart and select 'Edit Data' from the context menu. A small Excel worksheet window will appear.

3
Add the new categories

Type your new X-axis categories (e.g., new weeks or dates) into the rows or columns directly adjacent to the existing data.

4
Expand the range outline

Locate the small sizing handle at the bottom-right corner of the colored outline that surrounds your original data. Click and drag this handle outwards to include the newly added rows or columns. The chart will update instantly.

Extend the Data Range Using Edit Data
Missing Colored Outline: If you are editing an older chart and the colored range outline does not appear in the worksheet, you may need to use the 'Select Data' dialog method instead.
Professional Presentation Tool

Easily Manage Chart Data with WPS Presentation

WPS Presentation provides a highly intuitive, built-in spreadsheet interface to manage your chart data seamlessly. You can easily add X-axis categories, drag to expand data ranges, and ensure your visualizations are perfect without dealing with missing menu options.

  1. 1. Open the presentation: Launch WPS Presentation and open the slide containing your chart.
  2. 2. Edit the chart data: Click the chart, then click the 'Edit Data' icon that floats next to the chart to open the integrated spreadsheet.
  3. 3. Expand the data range: Type your new X-axis categories, then simply drag the clearly visible blue border handle to include your new cells. The chart updates automatically.
Fully compatible with Microsoft PowerPoint (.pptx) formats and embedded Excel charts.Intuitive drag-and-drop handles make expanding chart data ranges instantly recognizable.Built-in spreadsheet engine prevents the need to jump between multiple heavy applications.Lightweight, fast, and free to use with a familiar user interface.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my PowerPoint chart not update automatically when I type new data?

PowerPoint charts only pull information from a strictly defined range of cells. Simply typing data next to the existing cells does not automatically add it to the chart; you must manually drag the range indicator box to tell the chart to include those new cells.

Where is the 'Select Data' option in PowerPoint for Mac?

If you created the chart natively in PowerPoint, you generally adjust the data by choosing 'Edit Data' and dragging the colored box around the cells. The 'Select Data' option typically only appears if you open the chart in the full Excel application via the 'Open Worksheet Object' command.

Can I link my PowerPoint chart to an external spreadsheet file so it updates automatically?

Yes. Instead of creating the chart in PowerPoint, create it in Excel first. Then, copy the chart and paste it into PowerPoint. Under the Paste Options menu that appears, select 'Keep Source Formatting & Link Data'. Future changes made in the Excel file will reflect in PowerPoint when you refresh the data.