And my 2 cents...

Be sure your sheet zoom is set to 100%.

Charts have weird behavior with other settings...

--
sb
"Jon Peltier" wrote in message
...
Excel 97? I never did much with Legend formatting in '97, but I know it
can really mess up plot area formatting if the chart isn't completely on
screen. I can't say much about your specific problem beyond that, other
than try to (temporarily) center the chart on screen, make your changes,
and put the chart back.

If the legend is wide enough to fit more than one entry across, it fills
them across first, then down.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

n/a wrote:

Hi

I intend to maximize the width of the legend within two axis. I
reposition it myself using this code:

If .HasLegend Then
.Legend.Width = .PlotArea.InsideWidth
.Legend.Left = .PlotArea.InsideLeft
.Legend.Top = 1
End If

But it is not working when I use
Application.ScreenUpdating = False

If
Application.ScreenUpdating = True
then only charts shown on the screen while updating / creating are
done right.

What is going on ?


Secondly I want to have the legendentries to occupy one line each
instead of one line all together. Can that be accomplished ?



Yours