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: 248
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:
- Turn Prisoner numbers into text by having ="24601" and ="0.50"
- 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:
- Ask Excel to format the first row's numbers as text.
© Super User or respective owner