How to Add More X-Axis Categories to a PowerPoint Chart on Mac
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.

- 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.
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.
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.
Click on the chart in your PowerPoint slide to select it and reveal the Chart Design tab.
Right-click the chart and select 'Edit Data' from the context menu. A small Excel worksheet window will appear.
Type your new X-axis categories (e.g., new weeks or dates) into the rows or columns directly adjacent to the existing data.
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.

Use Open Worksheet Object for Pasted Charts
Use this method if the chart was originally created in Excel and pasted into PowerPoint as an embedded object.
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. Open the presentation: Launch WPS Presentation and open the slide containing your chart.
- 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. 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.

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.




