How do I make the first row of an Excel chart be treated as a heading when it's a number?

Posted by Andrew Grimm on Super User See other posts from Super User or by Andrew Grimm
Published on 2011-06-22T02:59:49Z Indexed on 2011/06/22 8:25 UTC
Read the original article Hit count: 211

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.

© Super User or respective owner

Related posts about microsoft-office

Related posts about excel-2007