That Excel user is doing everything right, but the tool is doing everything wrong. The frustration described, selecting the correct data range, adding a second series, then watching the chart collapse into visual noise, is not a user error. It is a design failure that has persisted across decades of spreadsheet software.
The problem is painfully familiar. You want a clean dual-axis chart with proper labels. You know the data. You know the story it should tell. But the moment you try to add that second series, the chart reinterprets your intention. Labels vanish. Axes shift. What should be a clear comparison becomes a puzzle you have to solve with workarounds. The user tried selecting B10:F10 alongside their main data block. That should have worked. Instead, the graph "looked completely different." That is not a learning curve. That is a broken interface.
What this reveals is a deeper truth about how traditional spreadsheets treat data and visualization as separate worlds. You build your data in rows and columns with care, but when you ask for a chart, the software guesses at your meaning. And when you try to correct that guess, it often resists. The user in this example is following a book's instructions, yet the result still falls short, no "Year" label on the x-axis, no clean dual-axis behavior. The book can explain the steps, but the software cannot intuit the goal.
This matters because charts are not decorative. They are how we discover patterns, present findings, and make decisions. When the tool derails that process, it costs time and clarity. Every minute spent wrestling axis labels is a minute not spent analyzing the data itself. The solution is not to learn more obscure tricks. It is to use a tool that treats charts as a natural extension of your data model, one where labels, axes, and series relationships are explicit, not guessed.
Stop fighting the axis. Demand software that understands the chart you mean to make, not the one it assumes.