Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing only Legend Text | Charts and Charting in Excel | |||
How do I put text in a chart legend box? | Charts and Charting in Excel | |||
How can I find repeated numbers that are transposed? | Excel Discussion (Misc queries) | |||
= (other sheet, but transposed!) | Excel Discussion (Misc queries) | |||
superscript text in legend | Charts and Charting in Excel |