Chart Wizard, Excel

Use Excel s Chart Wizard function to plot these points, as in Fig. 10.2. 

Prepare a heatup path for 12 volume% S02, 13.2 volume% 02, 74.8 volume% N2, 675 K feed gas - as described in Appendix I. Plot the path with Excel s Chart Wizard function. 

Plot your Problem 12.1 points as in Fig. 12.1. Use Excel s Chart Wizard. 

We have used Microsoft Excel for all our calculations. We have found it especially useful for matrix calculations. We also like its Goal Seek, Visual Basic and Chart Wizard features. All the Excel techniques used in this book are detailed in our forthcoming book Excel for Freshmen. Please note that, consistent with Excel, we use for multiply throughout the book. 

Excel 2000 uses the column chart type as the default chart format, but you can change the default to any of the other built-in chart formats (most likely you d want the XY chart type to be the default). You can also set your own chart format as the default, and thus convert the Chart Wizard from a four-step wizard to a one-step wizard, so that by simply pressing the Chart Wizard s Finish button in the Chart Wizard Step 1 of 4 dialog box, you can go directly to the completed chart. 

Plotting o Graph of the Data and the Least-Squares Fit It is customary and useful to plot a graph of the data and the least-squares fitted line similar to Figure 8-9. The built-in Chart Wizard of Excel makes creating such plots relatively easy. There are several ways to display the data points and the predicted line simultaneously. One way is to plot the predicted values y and the experimental y values simultaneously. The predicted values are given in Table 8-2. The easiest way is to have Excel add the line, called a TrendLine, itself. 

In Excel 97 or a more recent version, go with the mouse pointer to the menu bar, click on Insert, and in the resulting drop-down submenu click on Chart. Or achieve the same result with the keystrokes Alt + i, Alt + h. Either method will produce a dialog box labeled Chart Wizard - Step 1 of 4 - Chart Type. 

The Chart Wizard is the usual starting point for graphs in Excel, and a number of different formats are on offer. For calibration graphs always choose the XY (Scatter) plot, which is about halfway down the menu. Do not choose Line which spaces out the points equally. 

Excel can be used to produce graphs of various kinds (Excel refers to graphs as charts ). We present a procedure to constmct a two-dimensional graph using the Chart Wizard. The graph is constracted from values of an independent variable in one column values of a dependent variable in another column. These values must first be loaded into the columns. After the values have been loaded into the spreadsheet, you follow the procedure ... 

Excel offers Chart Wizard, which is a series of dialc e boxes that walks you through the necessary steps to create a chart To create a chart using the Excel Chart Wbtaid, follow the procedure explained here. 

In MS Excel, plot PCI vs. PC2 from the PCA sheet/tab by selecting the columns and clicking on the Chart Wizard icon in the Standard Toolbar (View>Toolbars>Standard). 

---