《用excel创建曲面图》由会员分享，可在线阅读，更多相关《用excel创建曲面图（3页珍藏版）》请在金锄头文库上搜索。
1、用 EXCEL 创建曲面图Creating a Surface chartShow AllAPPLIES TOMicrosoft Office Excel 2003Microsoft Excel 2002A Surface chart shows a three dimensional surface that connects a set of data points. A Surface chart is useful when you want to find optimum combinations between two sets of data. Like a topographi
2、c map, the colors and patterns in a Surface chart indicate areas that contain the same range of values. Unlike other chart types, colors in a surface chart are not used to distinguish each data series. Instead, colors are used to distinguish the values.Its important to organize the data in your work
3、sheet in a similar fashion as the data shown in the following picture. Note that the temperatures are entered as column headings, and the seconds are entered as row headings. When you use this data to create a Surface chart, it will be plotted as follows:The row headings (seconds) appear along the s
4、eries axis (y-axis).The column headings (temperatures) appear along the category axis (x-axis).The data in the center of the worksheet (tensile strength) will be plotted along the value axis (z-axis).Surface chart typesA Surface chart can be displayed in different ways by selecting the following cha
5、rt sub-types: 3-D Surface This chart shows a 3-D view of the data, which could be imagined as a rubber sheet stretched over a 3-D Column chart. It is typically used to show relationships between large amounts of data that may otherwise be difficult to see. Wireframe 3-D Surface A variation of the 3-
6、D Surface chart that appears in black and white. Without color in the surface, a wireframe chart shows only the lines. Contour A Contour chart provides a 2-D view of the Surface chart from above, similar to a 2-D topographic map. The lines in a Contour chart connect interpolated points of equal valu
7、e. Wireframe Contour A variation of the Contour chart that appears in black and white. Without color in the surface, a wireframe chart shows only the lines.Create a Surface chart1. Select the data you want to display in a Surface or Contour chart.2. On the Insert menu, click Chart.3. In the Chart ty
8、pe box, click Surface.4. Under Chart sub-type, click the type you want to use.For a quick preview of the chart you are creating, click Press and Hold to View Sample.5. Click Next, and continue with steps 2 through 4 of the Chart Wizard. For help on any of the steps, click the question mark (?) on th
9、e Chart Wizard title bar.Changing the format of a Surface chartBecause the colors in a Surface chart are based on the values rather than the data series, you cannot select them in the chart itself. You can, however, select the corresponding color keys in the charts legend, and then make the formatti
10、ng changes you want in the Format Legend Key dialog box. Using this dialog box, you can: Change the colors and patterns used in the chart. Reorder the data series. Change the depth of the chart. Apply 3-D shading.For example, changing the colors and depth of the previous chart can make a Surface cha
11、rt much easier to read, as shown in the following picture.Format a Surface chart1. On the Surface chart, make sure the legend is displayed.How?2. In the legend, click the key for which you want to change the format.3. On the Format menu, click Selected Legend Key.4. On the Patterns tab, make the col
12、or, border, or fill effect changes you want.5. Repeat step 2-4 for each level you want to format.6. To change the order of the data series in the chart, click the Series Order tab, click a series name in the Series order box, and then click the Move Up or Move Down buttons.7. To change the depth of
13、the Surface chart, click the Options tab, and then type a value between 20 and 2000 in the Chart depth box.NOTE By default, the depth of the Surface chart is set to 100.8. To add a 3-D shading effect to the Surface chart, on the Options tab, select the 3-D shading check box.NOTES You can see the eff
14、ects of your changes in the preview box on the Series Order tab or the Options tab. The number of colors shown in a Surface chart is dependent on the scale settings of the value axis. Changes you make to a Surface chart may affect the size of the chart and those scale settings, showing more or fewer colors.摘自：http:/
