How do I fix transposed legend text?

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

I've made a bar graph. Two of my bar labels in the legend have mysteriously
transposed their text (e.g. I typed in "1 uM AF" and what appears on the
chart is "uM AF 1"). I've tried referencing cells with the correct label and
the same transposing happens. Why did this happen and how do I fix it?
 
Hi,

Forgot to ask, where did you type in the 1 uM AF, in the spreadsheet as a
title for the series or in the Series function or in the Series Name box in
the wizard/Sort Data?

One thing you might try is to select the series on the chart and edit the
SERIES function:

=SERIES("1 uM AF",'Drop Lines'!$A$2:$A$13,'Drop Lines'!$B$2:$B$13,1)

When you enter a series title using this method it is the first arguments
and it must be quoted, or it must be a range name or number, here it must be
quoted. This is the only thing you should modify, the rest is just my dummy
data.
 
Back
Top