To set the contour plot z-axis legend scale in Excel 2007, you can follow these steps:

1. Select the contour plot chart by clicking on it.
2. Click on the "Layout" tab in the ribbon.
3. Click on "Axes" in the "Labels" group.
4. Click on "Primary Vertical Axis" or "Secondary Vertical Axis" depending on which axis you want to adjust.
5. Click on "More Primary Vertical Axis Options" or "More Secondary Vertical Axis Options" at the bottom of the drop-down menu.
6. In the "Format Axis" dialog box, you can adjust the minimum, maximum, and major unit values for the axis scale under the "Axis Options" tab.
7. Click "Close" to apply the changes.

As for getting rid of the 3-D look of the contour plot in Excel 2007, you can follow these steps:

1. Select the contour plot chart by clicking on it.
2. Click on the "Design" tab in the ribbon.
3. Click on "Change Chart Type" in the "Type" group.
4. In the "Change Chart Type" dialog box, select the "Surface" chart type.
5. Select the "Flat Surface" sub-type.
6. Click "OK" to apply the changes.

This will change the contour plot to a flat surface with uniform colors for a given range of data, similar to the 2003 contour plot look.