Add Data Series and Switch Rows/Columns

Why series and row/column control matter on MO-210

Domain 5 continues past creating a chart into Modify charts. Two closely related Associate skills are Add data series to charts and Switch between rows and columns in source data. On performance projects, you often insert the right chart type first, then discover a missing series, an extra series, or categories sitting where the legend belongs. Graders score the finished chart—correct series, correct category axis—not whether you rebuilt the chart from scratch.

Task wording you will see includes "Add the Q4 series to the clustered column chart", "Include the Target column as an additional data series", "Switch the chart so months appear on the category axis", "Switch row/column so products are series", or "Use Select Data to add the West region values." Those map to Chart Design → Select Data and Switch Row/Column.

What Excel means by series vs categories

A chart plots one or more data series against a set of categories (horizontal axis labels on a column/line chart, or slice names on a pie).

If months appear in the legend and product names sit on the axis when the project wanted the opposite, you do not delete the chart—you Switch Row/Column or fix the series list in Select Data.

Select Data Source—the primary MOS tool

1. Click the chart so Chart Design is available.
2. On Chart Design, open Select Data (Data group).
3. The Select Data Source dialog shows:
   • Chart data range — overall source reference (editable).
   • Legend Entries (Series) — list of series with Add / Edit / Remove.
   • Horizontal (Category) Axis Labels — Edit to point at category cells.
   • Switch Row/Column — button that flips series ↔ categories interpretation.

Keep this dialog as your first stop when the chart is almost right but incomplete or oriented incorrectly.

Add a data series

When the project says to add a series that was not in the original selection:

1. Open Select Data.
2. Under Legend Entries (Series), click Add.
3. In the Edit Series dialog:
   • Series name — select the header cell (for example E3 containing Q4) or type the name if the task allows a literal.
   • Series values — select the numeric range (for example E4:E10). Clear any default ={1} placeholder before selecting so you do not append junk values.
4. Confirm OK on Edit Series, then OK on Select Data.

Verify the new legend entry and that plotted points/bars match the added column or row. If categories were already correct, you usually do not need to re-edit category labels just because you added one series—only edit categories when they are wrong or empty (1, 2, 3…).

Edit or remove a series

• Edit — change name or values when the wrong range was captured or the project renames a series header you must reflect.
• Remove — delete a series the project says to exclude (for example remove Totals from a column chart). Prefer Remove over hiding worksheet columns unless the descriptor tells you to hide data.

Order of series in the list often follows plot order. Associate tasks rarely require reordering series manually; if legend order matters and a project specifies it, check whether editing the data range left-to-right or using the list order tools available in your Excel build satisfies the ask—do not invent unrelated Format tasks.

Fix category axis labels

If the axis shows 1, 2, 3 instead of region names:

1. Select Data → Horizontal (Category) Axis Labels → Edit.
2. Select the label range (for example A4:A10).
3. OK twice.

This is common when someone selected only value columns at insert time. Adding categories here is often faster than recreating the chart.

Switch Row/Column

Switch Row/Column (on Chart Design and inside Select Data) tells Excel to reinterpret the same rectangular source: what was treated as series becomes categories and vice versa.

When to use it

• After insert, months are legend entries and products are on the axis—but the project wants months on the axis and products as series (or the reverse).
• A line chart of time trends shows one line per month instead of one line per metric across months.
• The chart "looks sideways" relative to how the worksheet table is arranged, even though the overall data range is correct.

When not to use it

• A series is simply missing from the range—Add the series (or expand Chart data range) instead of switching.
• The wrong chart type was chosen—use Change Chart Type, not Switch Row/Column.
• Categories are blank because labels were never selected—Edit category labels rather than switching blindly.

Switching twice returns you to the previous orientation. On the exam, apply Switch Row/Column once, then visually confirm axis vs legend against the descriptor before moving on.

Expanding the chart data range vs adding one series

Two valid approaches when an adjacent column should be included:

1. Chart data range — edit the overall reference from A3:D10 to A3:E10 so Excel picks up the new header and values as another series (works well when the new series sits in a contiguous block with the existing source).
2. Add — define Series name and Series values explicitly (works when the new series is not contiguous or when expanding the full range would accidentally include a total column).

If expanding the range would pull in a Grand Total column the project does not want, use Add for only the needed series, or expand then Remove the total series.

Tables as chart sources

When the chart is based on an Excel table, new table columns often appear as available series more readily when you refresh selection or expand the data range. Still follow the project: if it says add the Commission series, open Select Data and confirm Commission is listed—do not assume the chart auto-updated if the series was outside the original chart range. Do not convert the table to a range merely to add a series unless asked.

Combo charts and series identity

On combo charts, each series still appears in Select Data. Adding a Target series may require a later Change Chart Type → Combo step so Target plots as a line while Actual stays columns. That type change is a related Domain 5 skill; this section's job is ensuring the series exists with the correct values. Complete Add / Select Data first, then adjust combo subtypes if the project requires both.

Worked exam-style scenarios

Scenario A — Add Q4. Chart already plots Q1–Q3 from A3:D10. Project: Add Q4 (column E) as a data series. Select chart → Select Data → Add → Series name E3, Series values E4:E10 → OK. Confirm four legend entries.

Scenario B — Wrong orientation. Data has regions in rows and months in columns. Clustered column shows regions as series. Project: Switch the chart so months are series and regions are categories (or the wording matching your sheet). Click Switch Row/Column once; verify legend and axis.

Scenario C — Categories missing. Values-only selection created a pie with Slice 1, Slice 2. Select Data → Edit category labels → select the name range. Do not recreate the pie unless type is also wrong.

Common exam pitfalls

• Recreating the entire chart instead of Select Data when only one series is missing.
• Leaving the default ={1} in Series values so the new series plots a single useless point.
• Expanding the data range to include a Total column the project never asked for.
• Using Switch Row/Column when the real problem is a wrong chart type.
• Editing worksheet data layout (cut/paste transpose) when Switch Row/Column would satisfy the task without destroying the table.
• Selecting a chart element only (one bar) and wondering why Select Data is limited—click the chart border so the whole chart is selected.
• Adding a series by typing values as static arrays when the project expects a live worksheet reference—prefer cell ranges so updates and grading see linked data.

Practice sequence

1. Create a clustered column chart from A1:C6 (categories + two series). Use Select Data → Add to include column D as a third series.
2. Remove the third series, then expand Chart data range to include column D again—compare both methods.
3. Intentionally insert with categories and series swapped relative to a goal layout; fix with Switch Row/Column only.
4. Build a chart from values only; repair category labels via Select Data → Edit.
5. Add a non-adjacent series (for example values in column G) with Add, without including F if F is a blank or unused column.

Master Select Data (Add / Edit / Remove / category labels) and Switch Row/Column, and you cover adding series and switching rows/columns for MO-210 Domain 5.