Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Given a data sample like

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

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:

  1. Turn Prisoner numbers into text by having ="24601" and ="0.50"
  2. Only select rows 2 onwards as data, and then add in the labels once the graph has been created?

Approaches that don't appear to work:

  1. Ask Excel to format the first row's numbers as text.
share|improve this question
@linger I submitted an edit to remove the 'graphs' tag because it's deprecated. See…;. – Kenster Sep 20 '14 at 2:00
@moses I submitted an edit to remove the 'graphs' tag because it's deprecated. See… – Kenster Sep 20 '14 at 2:01
up vote 1 down vote accepted

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

share|improve this answer

Have you tried putting a ' (apostrophe) in front of the number? This should make the number a text, but still view it without the apostrophe, or is this approach on par with the ="1234" and not what you want?

share|improve this answer
You'd have to manually modify each cell, like approach 1 in the question, right? – Andrew Grimm Jul 7 '11 at 1:35
It appears you have to, yes – private_meta Jul 7 '11 at 16:16

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.