Wizard Chart

Graphs can be produced either by selecting the Insert menu and the Chart option, or by using the Chart Wizard symbol jj(. Most graphs in this book are produced using an xv plot or scatterplot, allowing the value of one parameter (e.g. the score of PC2) to be plotted against another (e.g. the score of PCI). 

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. 

You can use the Chart Wizard toolbutton fl to create a chart. To use the Chart Wizard, first select the data to be plotted, e.g., a column of x values and a column of y values. The data can be in rows or columns. If the rows or columns... 

Figure 2-1. The first Chart Wizard dialog box choosing chart type.

Figure 2-2. The second Chart Wizard dialog box a preview of the chart.

Figure 2-3. The third Chart Wizard dialog box adding or removing chart elements.

Figure 2-4. The fourth Chart Wizard dialog box determining the location of the completed cnart.

Options..., Location... — correspond to the four dialog boxes of the Chart Wizard. You can use these commands to modify a chart that you ve already created. 

Another way to plot two sets of x, y data on a single chart is by means of the data layout shown in Figure 5-7. To use this approach, select the X cind Y1 values (A2 B8) and use the Chart Wizard to create a chart. Next, select the X and Y2... 

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. 

Figure 5-20 shows an Arrhenius plot, in which kinetics data is plotted in the form In vs. 1/T. It is common in such plots to provide, for clarity, an additional X-axis scale showing the actual temperatures used. Often this additional X-axis scale is displayed along the bottom of the chart, sometimes it is placed at the top, as shown here. It isn t possible to provide an additional scale like this using the tools provided by the Chart Wizard, but it can be done by "hand crafting". The upper scale is a "fake" scale — the Tick Marks are a data series, the Tick Mark Labels are data labels. 

The Chart Wizard always uses the leftmost column (of those that you selected) for the x values when it creates an XY chart. To change the plotting order, so that values from a column other than the leftmost one are used as the x values, you must first create a chart in the normal way, then either ... 

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. 

To plot the points, select the xy data (cells B2 D6) from the original worksheet. Cliek on the Chart Wizard icon shown in the margin. Select XY(Scatter) from the standard types list and click on Next>. When the Step 2 of 4 window appears, click on Next> again. Click on the Gridlines tab, and check Major gridlines under Value (X) axis. Then click on the Titles tab, and enter x in the Value (X) axis blank and y in the Value (Y) axis blank. Finally, click on Finish to produce the following graph of the data. 

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. 

Step 2 of the Chart Wizard shows the Data range selected. Also, under the Series tab, it shows which column will be used for X-values, and which for Y-values. The default (i.e., the assumption the spreadsheet makes in case you do not overrule it) is to use the left-most column of the selected block for X-values, so you need not take any action here, just press on with Next >. But it is handy to know that you can here, in step 2 of the Chart Wizard, change the assignments forX and Y. 

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. 

Chart Wizard - Step 2 at A - Chart Source Data... 

---