You need to format the value axis. Depending on you chart sub type this
axis may not be mouse selectable. If you have the 3d view then it's the
vertical value axis you need to select. From there changing the Min/Max
and Major values will alter the legend bands.

This works great. Change to 3D graph and edit the Z-axis. After that
swich back to 2D.


For the 2d views you can use either, Chart Tools Format Current
Selection. Pick Vertical (Value) Axis and then click Format selection.

I can't quite figure out where the "Chart Tools" are located in
Excel2007. I have a Danish version and therefore not the same names.


Or you can display the Format dialog and then click back to the chart
and use the Down arrow to cycle though the major chart elements. Make
sure it's the down arrow as the up arrow does not go through the axis
items.

This also works, but I never have found this feature by my self. I will
use this (or the 3D convertion) in the future.

Thanx a lot for the very informative answer. Good that I can ask you
guys since Microsoft has made it very difficult to change this for a
"normal" user.

Lars