How do I make the first row of an Excel chart be treated as a heading when it's a number?
- by Andrew Grimm
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.
