Add a Data Series or Bar to an Excel Chart
Question details
Add another data point, category, or series to an existing Excel bar 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.
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.
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.
Click anywhere in the existing bar chart to display the Chart Design tab.
On the Chart Design tab, click Select Data.
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.
Click OK and check that the new bar or series and its label appear in the chart.

Add a separate series to an Excel chart
Use this method when you want to add a series without expanding the chart's entire source range.
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. Open the workbook: Launch WPS Spreadsheet and use Open to select your Excel workbook.
- 2. Enter the new data: Add the new values and their label or heading next to the existing chart data in the worksheet.
- 3. Edit the chart source: Click the chart and choose Select Data from the chart tools or the chart's right-click menu.
- 4. Include the new cells: Expand the chart data range to include the new cells, then confirm the selection and check the chart.

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.




