Embedded chart

There are two ways to create a chart either as a separate chart sheet in a workbook, or as a chart embedded in a worksheet, so that you can see both the data and the chart at the same time. An embedded chart is useful if you want to see how a curve changes as you change its parameters. As you change the values in worksheet cells, the chart will update automatically. 

A plane schematic drawing of the thick film oxygen sensor is shown in Figure 3. The protective layer is eliminated. A part of each platinum lead wire is embedded in the alumina substrate. The earth line of the heater and sensor is common. Figure U shows a production flow chart for the thick film oxygen sensor. 

To copy a chart, select the chart by clicking in the chart border. Then choose Copy from the Edit menu. A marquee will appear around the chart. Activate the Word document, position the cursor where you want the chart to appear in the document, then choose Paste. The appearance of the copied chart will be a little different, depending on whether you copied a chart in a chart sheet or an embedded chart. Most noticeably, the copy of an embedded chart will have a border to remove the border from the chart before copying, choose Object... from the Format menu, then choose the Patterns tab, then Border = None. 

The fourth dialog box allows you to create the chart either as a new chart sheet, which will be inserted in the workbook, or as an embedded chart on a worksheet (Figure 2-4). 

To activate (select) an embedded chart for moving, re-sizing or formatting, you simply click once cn the chart. When selected, an embedded chart has black "handles" at the sides and comers. In earlier versions of Excel you double-clicked on a chart to activate it but, beginning with Excel 97, only a single click is necessary to activate an embedded chart. 

To move an embedded chart, place the mouse pointer anywhere inside the chart and click and drag the chart to its new location. To change the size of the chart, click on one of the handles, then drag to move that edge or comer inward or outward. 

When you activate an embedded chart (by clicking cn it) or switch to a chart sheet, the Worksheet Menu Bar is replaced by the Chart Menu Bar. The first four commands in the Chart menu — Chart Type..., Source Data..., Chart... 

USING LOCATION... IN THE CHART MENU TO MOVE OR COPY AN EMBEDDED CHART TO A SEPARATE CHART SHEET OR VICE VERSA... 

If you created an embedded chart and would like to convert it to a separate chart sheet, simply activate the chart, choose Location... from the Chart menu, press the As New Sheet option button, then press OK. The embedded chart will be converted into a chart on a separate chart sheet. To put a copy of an embedded chart on a separate chart sheet, first make a copy of the chart, then follow the same procedure. 

Highlight the range of data to be added to the chart and Copy. Switch to the chart sheet or activate an embedded chart by clicking on it. Paste the data. The new data will be added to the chart. 

THE DRAG-AND-DROP METHOD (FOR EMBEDDED CHARTS ONLY)... 

This method can be used only for embedded charts with data in adjacent ranges of cells. A chart with data in non-adjacent ranges does not display color-coded ranges when you click on the plot area. 

EDITING THE SERIES FUNCTION IN THE FORMULA BAR (FOR EMBEDDED CHARTS OR SEPARATE CHART SHEETS)... 

First, switch to the chart sheet or activate an embedded chart by clicking on it. Click on the desired data series in the chart. The definition of the data series, in the format =SERIES(name, x-values ref, y-values ref, p ot ordex, for example =SERIES("Series2", Sheet4 A 1 A 11, Sheet4 C 1 C 11, 2) will appear in the formula bar. Edit the references for both X and Y values to include the additional data points. Sometimes this is the fastest way. 

Select the three data series (x, yobsd 3/cak) create an XY chart. If you created an embedded chart, you ll have to select it (dick on it) before you can proceed to customize it. 

Create the main chart as an embedded chart or as a separate chart sheet. Customize it and size it as desired. 

Create the inset chart as an embedded chart, and size it appropriately to fit in the main chart. 

The chart must be activated. If the chart is an embedded chart, you must activate it by clicking on it,... 

A simpler form of the Gaussian band shape, where a is simply treated as an adjustable parameter, is given in equation 21-5. This is the equation that will be used in the following treatment. By using an embedded chart to compare calculated and experimental data, you can fairly easily find a set of A ax/ Vmax and a values that approximate the band shape, to use as initial guesses for the deconvolution procedure outlined in the box on the following page. 

Create an embedded chart, plotting /lobsd calc-... 

Software is available that will perform calculations of humidity parameters for any point value, and for plotting psychrometric charts. Moreover, British Standard BS 1339 Part 2 (2006) provides functions as macros which can be embedded into any Excel-compatible spreadsheet. Users can therefore generate their own tables for any desired combination of parameters as well as perform point calculations. Hence, the need for published lookup tables has been eliminated. However, this software, like the previous lookup tables, is only valid for the air-water system. For other vapor-gas systems, the equations given in previous sections must be used. 

---