Plotting with Excel

Today s spreadsheets offer many choices when it comes to creating charts. You can create column charts (or histograms), pie charts, line charts, or xy charts. As an et fneering student, and later as a practicing engineer, most of the charts that you will create wiU be of type charts. Therefore, next we will explain in detail how to create an oy chart 

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. 

First we will select the data range as shown. 

Next dick the Chart Wizard icon from the toolbar buttons and sdect the XY chart type. Also select the Chart sub-type, as shown. Click the Next button. 

You will now see the Chart Source Data window with the selected data range in the Data Range box. Click the Next button. 

---

Plotting with Excel 395 4. In the Hame box, type Miles Per Gallon and then press the Add button. 

For (Li, Cs)Cl, the internal mobilities have been calculated from Eqs. (27) and (28), and are given in Table 8. The SEVs were calculated from the same MD runs and are plotted against the calculated internal mobilities in Fig. 17 with excellent correlation between these calculated quantities. The good correlation of the SEV with the calculated and experimental internal mobilities suggests that relatively short-range cation-anion interaction plays a role in internal mobilities and the separating motion of pairs, that is dissociation, is related to the internal mobilities. In other words, the result of the SEV supports the dynamic dissociation model. 

Micropropagated raspberry is less tolerant to simazine, probably because of the shallow roots picking up more herbicide than the deeper rooting cuttings (Neal et al, 1990). When simazine was used in a New York study, weed control was excellent. However, with rainfall plus supplemental irrigation, there was less plant establishment and growth in herbicide-treated vines compared to mulched plants (Trinka and Pritts, 1992). It was determined that mulching provided a more uniform microclimate (moisture) than the plots with no weeds or cover. 

Figure 2.3. Linear regression analysis with Excel. Simple linear regression analysis is performed with Excel using Tools -> Data Analysis -> Regression. The output is reorganized to show regression statistics, ANOVA residual plot and line fit plot (standard error in coefficients and a listing of the residues are not shown here).

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. 

Thus, the experimental TT(/j) isotherms of NaDoS films plotted with the Thin Liquid Film-Pressure Balance Technique represent an excellent example of interpretation of long-and short-range interactions and the transition between them. 

We now consider the timing in a bit more detail. Here is a time line of the period we are considering (Figure N2-7). It is plotted in Excel, but you could also draw it by hand. We have left out the days of the two weekends, assuming that they will not be available. The days with lectures are coloured these are natural meeting points for the team. For simplicity you might assume that everybody works 2 hours per day on the project. 

This behavior may be compared with the (unnotched) tensile fracture energy, T, on the same plot. Clearly, excellent consistency is obtained. Thus either the energy for crack propagation dominates the... 

Nothing can be as helpful as displaying data in graphical form. With Excel you can quickly and easily create a chart, simply by selecting the data to be plotted and choosing the way you want the data to be displayed Excel does the rest. In this chapter you ll learn the basics of creating Excel charts. 

Sometimes you may want to create a type of chart that is not "built in". With a little ingenuity you can create some useful charts. The example below illustrates how technical users can improvise to add more information to an XY plot in Excel. 

It has been shown that the XES spectra can be simulated using DFT calculations with excellent agreement with experiment. In Fig. 12.7, orbital plots for gas phase... 

A major disadvantage of the extracted ion traces is the possibility of overseeing unknown by-products since only the expected masses are monitored. An excellent overview of all masses is given by the 2-dimensional landscape-plot with the retention times on the x-axis, and the molecular masses on the y-axis. Figure 17.21(a) and (b) show the TIC and the related landscape-plot respectively of apart of Figure 17.19(b). The common problem... 

Progressive changes in the dielectric behavior are found with increasing metal salt concentration, with the a process rapidly increasing in its temperature location until at 18% it is amalgamated completely with, or obscured by, the d process which then dominates the dielectric response. Frequency plane data for this d relaxation in the 18 mol % zinc chloride sample are shown in Figure 5. The relaxation is much sharper than a normal main-chain relaxation with the data giving excellent Cole-Cole (8) circular arc plots with the breadth parameter = 0.14. This reflects... 

The overall separation is displayed as a contour plot with two time axes. Peaks are presented as dots in this plane and the signal intensity by differences in color. TOF-MS provides an excellent means to use a chemometric approach. 

Figure 2. Helium diffusion Arrhenius plot with Otway Basin borehole constraint. The laboratory-measured He diffusion from this sample of Durango apatite defines an extremely linear array (filled symbols), consistent with simple thermally activated volume-diffusion. He age measurements from the Otway Basin provide a completely independent estimate of He diffusivity (open symbol), under natural conditions, which is in excellent agreement with the extrapolated laboratory data. Laboratory data are from Farley (2000). The Otway Basin constraint is from House et al. (1999).

The following diagrams have been calculated with EXCEL. The results are plotted in Fig. 5.8 to 5.10. Comparison with the data from Perry (1997) shows good agreement. 

Global SOO and MOO optimization methods, particularly recent ones, have been implemented and are readily available in Excel, MATLAB, C-i-i-, FORTRAN, and so on (Table 4.1). But, they may not be available in process simulators. So, interfacing between a process simulator (for example. Aspen HYSYS, Aspen Plus or ACM) and a global optimization program (for example, I-MODE in Excel) is necessary for improving the design of chemical processes. In particular, students and practitioners are familiar with Excel, and can easily use worksheets in Excel for computations, data analysis, plotting, and so on. 

Figure 2.2.16. Three-dimensional plot with perspective showing the excellent agreement between WW data and the results of fitting these data with the DAE model.

---