ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I fix transposed legend text? (https://www.excelbanter.com/charts-charting-excel/208434-how-do-i-fix-transposed-legend-text.html)

kate

How do I fix transposed legend text?
 
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?

ShaneDevenshire

How do I fix transposed legend text?
 
Hi,

I can't duplicate this problem, why don't you post a sample of the chart?
--
Thanks,
Shane Devenshire


"Kate" wrote:

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?


ShaneDevenshire

How do I fix transposed legend text?
 
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.
--
Thanks,
Shane Devenshire


"Kate" wrote:

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?



All times are GMT +1. The time now is 05:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com