To set the contour plot z-axis legend scale in Excel 2007, you can follow these steps:
- Select the contour plot chart by clicking on it.
- Click on the "Layout" tab in the ribbon.
- Click on "Axes" in the "Labels" group.
- Click on "Primary Vertical Axis" or "Secondary Vertical Axis" depending on which axis you want to adjust.
- Click on "More Primary Vertical Axis Options" or "More Secondary Vertical Axis Options" at the bottom of the drop-down menu.
- 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.
- 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:
- Select the contour plot chart by clicking on it.
- Click on the "Design" tab in the ribbon.
- Click on "Change Chart Type" in the "Type" group.
- In the "Change Chart Type" dialog box, select the "Surface" chart type.
- Select the "Flat Surface" sub-type.
- 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.