💻 Software

Make the first row of an Excel chart be treated as a heading when it's a number?

Fresh5 days ago

Mar 15, 202624422 views

Confidence Score0%

Problem

Given a data sample like What's the easiest way to tell Excel that 24601 and 0.50 are data series names rather than Y axis values when creating a line chart? Approaches I'm aware of: Turn Prisoner numbers into text by having ="24601" and ="0.50" Only select rows 2 onwards as data, and then add in t…

Error Output

Prisoner    24601   0.50
Day 1   80  90
Day 2   81  89
Day 3   82  90
Day 4   81  91

Unverified for your environment

Select your OS to check compatibility.

Your OS

OS version

Product version

1 Fix

Canonical Fix

Unverified Fix

New Fix – Awaiting Verification

Fix for: Make the first row of an Excel chart be treated as a heading when it's a number?

Low Risk

Clear the top left cell. The blank cell tells Excel that the first row (series names) and first column (category labels) are special.

Awaiting Verification

Be the first to verify this fix

Make the first row of an Excel chart be treated as a heading when it's a number?

Problem

Error Output

1 Fix

Fix for: Make the first row of an Excel chart be treated as a heading when it's a number?

Environment