To add a column of data as a new series in an Excel chart, select the chart, choose Chart Design > Select Data, click Add, and set the series name and values to the worksheet cells you want to plot. If you mean adding another category along the chart’s horizontal axis, expand the chart’s source range to include that category and its value.
What “add a column” means in an Excel chart
The phrase can refer to two different changes. A worksheet column may contain a new measure, such as 2025 sales beside 2024 sales; adding it to a chart creates a new data series. Or a column may contain another label or period, such as a new month; adding that information creates another category on the chart’s axis. The right method depends on which change you intend.
For example, suppose column A contains months, column B contains 2024 sales, and column C contains 2025 sales. If the existing chart shows months and 2024 sales, adding column C as a series lets you compare the two years month by month. If instead you add December beneath November in the existing data, you are extending the categories, not adding a new series.
A column chart is a chart type with vertical columns. Adding a worksheet column does not automatically change a line chart into a column chart, and adding a series to a chart does not necessarily make the new series appear as vertical columns. Those are separate choices: first include the data, then choose the chart type and layout that communicate it clearly.
Add a worksheet column as a new chart series
These steps apply to Excel for Microsoft 365 on Windows. Before editing, check that the new data has a heading and that its values line up with the categories already shown in the chart. For the monthly sales example, the 2025 heading should be in C1 and its twelve monthly values in C2:C13, aligned with the month labels in A2:A13.
- Click the chart to show the chart tabs on the ribbon.
- Choose Chart Design > Select Data. Excel opens the Select Data Source dialog.
- Under Legend Entries (Series), click Add.
- In Series name, select the cell containing the new heading, such as C1, or type a descriptive name.
- In Series values, select only the numeric cells for the series, such as C2:C13. Do not include the heading cell in this range.
- Click OK, then click OK again to close the dialog. Review the chart and its legend.
The selected values should correspond to the existing category labels. If the chart has twelve months, a twelve-cell series is normally appropriate. If the new data has a different number of entries, check whether labels or values are missing before assuming Excel has plotted the series incorrectly.
In Excel for Mac, select the chart and look for Chart Design > Select Data; ribbon names and dialog layout can vary slightly by release. Excel for the web supports many chart edits, but its controls may not expose every desktop dialog option. If you cannot add or adjust a series there, open the workbook in the desktop app and use Select Data.
Add another category or period to the chart
To extend a chart with a new month, product, or other category, include both the new label and its associated value in the chart’s source data. For example, if January through November occupy A2:A12 and the corresponding sales occupy B2:B12, enter December and its sales in the next row. Then select the chart and open Chart Design > Select Data.
In the dialog, update the Chart data range so it includes the new row, or adjust the category-axis labels and series values to include the additional cells. The chart data range is a quick option when the source data is a simple, rectangular block. Editing the individual ranges can be clearer when the chart uses non-adjacent cells or has several series. Click OK to apply the change.
You can also sometimes drag the colored outlines around the chart’s source cells on the worksheet to include the next row or column. This can be convenient for a straightforward chart, but it is easier to select the wrong cells when the source is large or separated into multiple ranges. Use Select Data when you need to see exactly which labels and values are assigned.
How Excel connects data to chart parts
A chart series is one related set of values, often represented by one color or legend entry. Categories are the labels used to group or position values, such as months, departments, or products. A chart can contain several series that share one category list. In a clustered column chart, for instance, each category can display a separate column for each series.
The Select Data Source dialog separates these jobs. Legend Entries (Series) lists the plotted measures. The Horizontal (Category) Axis Labels area controls the category names for charts that use a category axis. Choosing Switch Row/Column changes how Excel interprets the selected data: rows may become series and columns categories, or the reverse. It does not add new data; it changes the chart’s interpretation of the data already selected.
Headers help Excel identify series names, while labels help readers understand the axis. Including a heading among the numeric values can result in an unintended point or a range warning. Keep the heading in the series-name selection and the measurements in the values selection.
When a chart updates automatically
If a chart’s source is an Excel Table, adding data to the table may cause the chart to include the new row or column automatically. This behavior depends on how the chart and table are set up, so check the plotted chart rather than assuming that every addition has been picked up. A chart based on a fixed cell range may not include cells entered just outside that range.
To make a range into a table, select a cell in the data and choose Insert > Table, confirming that the data has headers if it does. Tables are useful for datasets that grow because their structured ranges can expand with the data. Even with a table, verify the chart after adding a new field: if a new measure does not appear, add it through Select Data or adjust the chart’s source.
For a chart that should remain fixed, do not expand its source range simply because more worksheet data exists. For a chart that should track new periods, decide whether an expanding table or an intentionally updated range is the better fit. This prevents a chart from silently including totals, notes, or unrelated columns.
Choose a suitable chart type and layout
After adding a series, check whether the current chart type still makes sense. A clustered column chart is useful for comparing series within each category. A stacked column chart emphasizes totals and each series’ contribution to those totals, while a 100% stacked column chart compares proportions rather than raw totals. A line chart may be easier to read when many periods or series make a column chart crowded.
To change the chart type in Excel for Windows, select the chart and choose Chart Design > Change Chart Type. Choose a type and, if available, a combination chart for series that need different visual treatment. A secondary axis may help when series have very different scales, but it can also make comparisons misleading if readers do not notice the separate scale. Label axes clearly and use the same units where possible.
Adding a series can make a chart’s legend and colors harder to interpret. Use meaningful column headings, remove redundant series, and consider data labels only when they improve readability. If one series is much larger than the others, small columns may seem to disappear; check the units and chart scale before changing the design.
Common problems and how to fix them
- The new series does not appear: Reopen Chart Design > Select Data and check that the series is listed and that its values refer to the intended cells. Confirm that the values are numeric rather than text that only looks like a number.
- The chart shows the heading as a data point: Edit Series values to exclude the heading. Set the heading cell separately as the Series name.
- The months or labels are wrong: Check the Horizontal (Category) Axis Labels range. Make sure it contains the intended labels and that its order matches the values.
- Excel plots rows and columns the wrong way around: Use Switch Row/Column in Select Data, then check the legend and axis. This is an interpretation change, not a repair to the worksheet itself.
- The new series has gaps or unexpected zeros: Look for blank cells, text, formulas returning empty text, or mismatched range lengths. Decide whether missing values should remain blank or be represented differently before changing the chart.
- The chart did not include a newly entered row: Check whether the source is a fixed range and extend it to include the new label and value. Data placed outside a fixed source range will not necessarily be plotted.
Remove or replace a series safely
If you added the wrong column, select the chart and open Chart Design > Select Data. Under Legend Entries (Series), select the unwanted series and click Remove. This removes it from the chart, not from the worksheet. To replace its source, select the series and choose Edit, then update its name or values. Confirm the ranges before closing the dialog, particularly if other series use nearby cells.
Deleting worksheet cells is different from removing a chart series. Removing cells can affect formulas or other charts that depend on them, whereas removing a series through Select Data changes only the selected chart’s plotted content. Use the chart dialog when your goal is to change what that chart displays while preserving the underlying data.
Frequently Asked Questions
How do I add a column to an existing Excel chart?
Select the chart, choose Chart Design > Select Data > Add, and set the series name and values to the new heading and numeric cells. If you mean a new category, expand the chart’s source range instead.
Why is my new column not showing in the chart?
The chart may still use a fixed source range that excludes the new cells. Open Select Data and check the series list and ranges. Also confirm that the selected cells contain numeric data and that the series is not hidden by the chart’s current layout.
How do I add a column without adding another series?
If you mean a new category such as another month, add its label and value to the source data and expand the chart range to include them. Do not use Add under Legend Entries (Series), because that creates a separate measure.
Can I add a column to a chart in Excel for the web?
You can edit many charts in Excel for the web, but some chart-source controls differ from the desktop app. If Select Data or the series-editing options you need are unavailable, open the workbook in Excel for Microsoft 365 on Windows or Mac.
How can I make the new series appear as columns?
Select the chart and choose Chart Design > Change Chart Type, then choose a column chart or an appropriate combination chart. Adding a series alone does not change the chart type.
Related
- Excel Merge Two Cells With Text Without Losing Data
- Excel Lock Slicer in Place? Position and Protect It
- Excel Slicer: Connect One Slicer to Multiple PivotTables
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Prepare a Waterfall Chart in Excel Step by StepTo prepare a waterfall chart in Microsoft Excel for Microsoft 365 on Windows, put each step in a…
- Excel Pivot Table: How to Exclude Zero Values?Yes. In an Excel PivotTable, use a value filter such as Does Not Equal 0 to hide row…
- Excel Radar Chart: Change the Axis ScaleIn Excel for Microsoft 365 on Windows, select the radar chart’s value axis, open Format Axis, and enter…
- Excel Combo Chart: How to Combine Bars and a Line in ExcelTo make a bar-and-line combo chart in Excel for Microsoft 365 on Windows, select your data, choose Insert…
- Year to Date in Google Sheets Pivot Tables: How It WorksTo show year-to-date (YTD) figures in a Google Sheets pivot table, add a helper column to your source…
- Remove a Column from an Excel Chart Without Deleting DataTo remove a column from an Excel chart without deleting its worksheet data, select the chart, open Chart…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.