Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

2 Answers

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
add comment

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
add comment

Your Answer

 
discard

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.