Excel 2007

  • Thread starter Thread starter wd
  • Start date Start date
W

wd

I am a student trying to learn/understand excel on my own, this is my question:
In a chart if I selected cells B5:B10, as my data series for a chart, and
specified the data series are in columns. What will be my legend text?
Cells B5:B10, Cells C6:F10, B5:B10, or impossible to determine.
 
What is the series name? That's what appears in the legend. Sometimes Excel
will correctly guess what to use, but you can take steps to ensure Excel
guesses correctly.

Set up your data as follows. In the first column, enter your X values or
category labels. In the second column, enter the Y values. In the cell above
the first X value (first category label), don't enter anything: leave it
blank. In the cell above the first Y value, enter a name for the series. If
you have multiple series, use additional column for the values and series
names.

Name
X1 Y1
X2 Y2
X3 Y3
X4 Y4
etc.

- Jon
 
Back
Top