Legend Problems

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sara.ziesman@gmail.com - 30 Jan 2007 22:10 GMT

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!

Reply to this Message

Bernard Liengme - 31 Jan 2007 19:28 GMT

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

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>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
[quoted text clipped - 4 lines]
> the following as a title "33 degC Hold Rep#1" entered, but it was
> displayed as "degC Hold Rep#1 33". Help!

Reply to this Message