Chart & Visualization Issues

Add a Data Series or Bar to an Excel Chart

Kushani NimanthikaKushani Nimanthika Nov 18, 2026 870 views

Question details

Add another data point, category, or series to an existing Excel bar chart.

How to Add a Data Series or Bar to an Excel Chart
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants an existing bar chart to include additional worksheet data.
Observed behavior
The chart should display the additional bar or series from the updated source data.
Before you start

Enter the new values in the worksheet, preferably next to the chart's existing source data. Include a category label or series heading so Excel can identify the new data.

Solution 1Recommended

Expand the Excel chart's source data range

Use this method when the new row or column is adjacent to the chart's existing source data.

1
Select the chart

Click anywhere in the existing bar chart to display the Chart Design tab.

2
Open the data source

On the Chart Design tab, click Select Data.

3
Expand the range

In the Chart data range box, select or enter a range that includes the existing data and the new row or column, including its label or heading.

4
Update the chart

Click OK and check that the new bar or series and its label appear in the chart.

Expand the Excel chart's source data range
Check the data orientation: If Excel treats the new data as a series when you intended a category, or vice versa, open Chart Design > Select Data and try Switch Row/Column.
Create and edit charts in WPS

Add chart data in WPS Spreadsheet

Open your workbook in WPS Spreadsheet and update the chart's data source to include a new row or column.

  1. 1. Open the workbook: Launch WPS Spreadsheet and use Open to select your Excel workbook.
  2. 2. Enter the new data: Add the new values and their label or heading next to the existing chart data in the worksheet.
  3. 3. Edit the chart source: Click the chart and choose Select Data from the chart tools or the chart's right-click menu.
  4. 4. Include the new cells: Expand the chart data range to include the new cells, then confirm the selection and check the chart.
Expand a bar chart to include additional worksheet dataOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interfaceCreate and update charts in a free office suite
microsoft office alternative - wps office

Frequently Asked Questions

How do I add one more category to an Excel bar chart?

Enter the category label and value next to the existing data. Select the chart, choose Chart Design > Select Data, and expand the Chart data range to include the new cells.

How can I add a series from a different range of cells?

Select the chart and open Chart Design > Select Data. Under Legend Entries (Series), click Add, then select the series name and numeric values.

Why did Excel add a series instead of a category?

Excel may be interpreting the rows and columns in the opposite orientation. Open Chart Design > Select Data and try Switch Row/Column, then check the chart labels.

Can I update an Excel chart in WPS Spreadsheet?

Yes. Open the workbook in WPS Spreadsheet, select the chart, and use Select Data in the chart tools or right-click menu to update its source range.