The Format Legend dialog has a Scale tab just like in a typical Format Axis dialog. To change the scale of the bands, format the legend. This didn’t cure the strange rendering, but at least improved it a bit. You can’t do much about the asymmetry I used to insert rows and columns in the source data, and interpolate values, to double the resolution. That scale is a bit coarse, and symmetrical features like the saddle point and the shapes of the colored bands in the corners are not symmetrically rendered. To format the bands, you format the legend key for that band, the small square in front of the label. I have removed the horizontal and vertical axis features (actually, the “category” and “series” axes), and selected a simple color scheme for the data bands. Select the data and insert a contour chart, and you will get something like this. Each value in the grid is the product of the corresponding row and column headers. ![]() That article was valid for Excel versions 97 through 2003, but like so many other aspects of charting, Excel 2007 changed all that.įor these examples, let’s use this simple dataset. ![]() In that article I outlined the data requirements for surface and contour charts, and described some of the formatting idiosyncrasies of these charts. ![]() Some time ago I wrote about Surface and Contour Charts in Microsoft Excel in Dian Chapman’s now defunct TechTrax Ezine.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |