ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Legend Problems (https://www.excelbanter.com/charts-charting-excel/128472-legend-problems.html)

[email protected]

Legend Problems
 
I have some x-y scatter plots where the series titles are pulled from
cells in the workbook. In the source data box the titles show up
right, but on the chart the last of the text is being moved to the
front. For instance, if the title is "33degC Hold (RE203)", it is
showing up as ")33degC Hold (RE203". Any ideas on what the problem
could be and how to fix it? It has also gone the reverse way. I had
the following as a title "33 degC Hold Rep#1" entered, but it was
displayed as "degC Hold Rep#1 33". Help!


Bernard Liengme

Legend Problems
 
Some suggestions:
1) More the legend to the bottom of the chart to give it more horizontal
room
2) Use ° (ALT+0176 on numeric key pad) in place of "deg"
3) If all fails, use call-outs from Drawing tool to hold long text and point
to each series
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
I have some x-y scatter plots where the series titles are pulled from
cells in the workbook. In the source data box the titles show up
right, but on the chart the last of the text is being moved to the
front. For instance, if the title is "33degC Hold (RE203)", it is
showing up as ")33degC Hold (RE203". Any ideas on what the problem
could be and how to fix it? It has also gone the reverse way. I had
the following as a title "33 degC Hold Rep#1" entered, but it was
displayed as "degC Hold Rep#1 33". Help!





All times are GMT +1. The time now is 08:22 PM.

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