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? |
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? |
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