There's a quiet frustration in the post from u/Downtown_Movie_9218, and we understand it completely. You've got your chemistry data laid out neatly, 1/K on one side, ln(Kx) on the other, and you just want a single line that tells the story of that relationship. Instead, the chart hands you two separate series, and suddenly what should be a straightforward graph becomes a puzzle about how the software thinks, not about your data. That's not a failure on your part. It's a matter of understanding what the tool expects from you before you click.
The issue here is that when you highlight both columns and insert a line chart, the program assumes every column is its own series. It doesn't read your intent, it reads structure. Your earlier success with Time and Temperature worked because both columns were likely in the same row order, and the software guessed that one was the x-axis and the other the y-axis. But with non-sequential cells like B3:B6 and D3:D6, the logic breaks down. The chart sees two independent sets of numbers and plots them as separate lines. The fix isn't complicated, but it requires you to take control of the axis assignment manually. Select the chart, open the data source settings, and explicitly set the x-axis values to B3:B6 and the y-axis values to D3:D6. Once you do that, you'll get the single line you're after.
What this reveals is a broader truth about spreadsheet tools: they are powerful, but they are not mind readers. The moment you step outside the most common pattern, adjacent columns, same row count, you're expected to clarify your intentions. That's not a flaw in your workflow; it's just the nature of the interface. The good news is that once you learn this one move, you'll never be thrown off by it again. You'll start seeing charts as something you build, not something you ask for and hope for the best. That shift in mindset turns a frustrating afternoon into a skill you'll use for every report, presentation, or analysis that follows.
So here's the concrete takeaway: when you're plotting two data series that should be one relationship, always verify which axis is which before you finalize the chart. Don't assume the software knows. Right-click the chart, choose "Select Data," and confirm that your x-values are the independent variable and your y-values are the dependent one. For your chemistry report, that means setting 1/K as the horizontal axis and ln(Kx) as the vertical axis. Do that, and your line will appear exactly as intended, one clean line, no ambiguity. That's the difference between wrestling with a tool and making it work for you.