Data labels

CREATE GENDER FIRST ROW FOR THE TABLE. data label ... 

The FDA evaluates each tumor marker test against its own labeling claims as to how well it performs and compares it with other cleared and marketed devices identified in the 510(k) submission. The intended use claim for monitoring must be supported by valid scientific and clinical data. Labeling a tumor marker test for a particular claim can mean that the testing system may have to show supporting data for that claim. For example, a tumor marker proposed for a monitoring claim will require laboratory and clinical data to support that claim (4,5). 

Plot the data Label the axes Examine the pattern... 

Figure 10. Factor score plots of analytical/sensory data. Labels are as in Figure T-...

Table 1. Sub-regional diversities derived from LPC data labelled a-r, between the two families. One or more Cot groups may correspond to those in the other family or may not correspond with any region in the other family (n/c). Labels in bold are discriminatory hydrogen-bondinginteractions. The subregions j and r are only found in some sites within family 1 but such sub-regions are ignored because they are either areas of either aliphatic or hydrophobic residues or charged residues beyond 3.5A from the ligand atoms and therefore non-interacting. ...

FIGURE 1 Empirical phase diagram for ricin toxin A-chain generated using CD molar ellipticity at 208 nm, ANS fluorescence, and intrinsic Trp fluorescence intensity data. Labels indicate the state of the protein within the same region of color based on evaluation of a compilation of data sets. (Reproduced with permission from ref. 62.)... 

General Information Ingredients Information Physicat/Ckemical Characteristics Fire and Explosion Hazard Data Reactivity Data Health Hazard Data Control Measures Transportation Data Disposal Data Label Data... 

The time-dependent rheological properties of disordered smectics are also peculiar. Figure 10-37 shows apparent G and G" data (labeled MD ) measured for 8CB after a quench from the isotropic state. Quenched samples contain a very high density of smectic defects, which produce elastic-like behavior in G at low frequencies of oscillation. The apparent moduli G and G" in Fig. 10-37 are not true linear viscoelastic moduli, since they were... 

The third dialog box (Figure 2-3) allows you to add or change titles, chart axis labels, gridlines, legend or data labels. (All of these can be added or removed after the chart has been completed.)... 

I i Titles n fees j Gridlines Legend Data Labels Chart title ... 

Data labels are text boxes associated with each data point of a chart series. You can choose to have either the label (the X value) or the value (the Y value) displayed as the data label. Neither of these two options is too useful, but you can manually edit the Data Label text to provide more useful information. 

To add data labels to a particular series in a chart, activate the chart and click on the series. Choose Selected Data Series... from the Format menu and choose the Data Labels tab. Choose either the Value option or the Label option, then press OK. 

To edit the text of a particular data label text, click once on the label to select all the data labels for a particular series, then a second time to select a single data label, then a third time to begin editing the text. 

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. 

When this approach is applied to Series 3 to provide Tick Mark Labels, you ll get two superimposed data labels at each x value (for example, 12 and 11.8 if you chose to display values.) This means that you ll have to select one of the two labels and delete it, then select the other label and edit it. A better way to add the data labels is to add a fourth data series with a single point for each tick mark in this example, select C20 D20,C23 D23,C26 D26,C29 D29 and Copy, add this as a new series. Series 4, using Paste Special, then format the series to set both Line and Marker to None. Then add data labels, either values (Y values) or labels (X values), to this series. Change the Alignment of the data labels to Above. Edit the data labels individually, replacing them with the desired text. 

Creating a Sub Procedure TO Apply Data Labels in a Chart... 

As described in Chapter 5, the Data Labels tab in the Format Data Series dialog box allows you to add data labels to a chart (to each data point in an XY chart, or to each column in a column chart, for example). But only the x values or the y values can be used as labels. You d probably like to use some other text as data labels. You can do this manually, by adding the data labels, then manually editing each one to enter the text you want. A macro will make the task much easier. 

In the following section we will develop a Sub procedure to assign text values in a range of cells as the data labels for a chart. Here s how we ll proceed we ll use the Recorder to obtain the code for adding data labels. 

In the first version of our macro, the chart must be the active document, and the user must have selected the data series to which the data labels are to be attached before running the macro. In a later version we ll allow the user to select the data series while the macro is running. 

Acti veC ha rt. SeriesCol I ection(l). Apply Data Labels... 

ActiveChart.SeriesCollection(1).Points(4). Data Label.Select Selection.Characters.Text = "abc"... 

To specify the range of cells to use as data labels, we ll use the InputBox method. We ll define the range as an object variable, so that we can use a For...Each...Next loop. For a code example, see "You Can Define Your Own Objects" in Chapter 14. To convert SeriesCollection(l) into the general case, remember that a specific item in a collection can be referred to by its index number or by its name. We ll use the code... 

Set LabelRange = Application.InputBoxfSelect the range of cells containing the labels", "DATA LABELER STEP 1 OF 18)... 

Set up a loop to replace data labels with new ones. 

Labeler1.xls is the Sub procedure shown in Chapter 16 that adds user-specified data labels to a chart. 

Labeler2.xls is a more advanced version of the Data Labeler macro. It uses a custom dialog box (not discussed in the text). See "Instructions for Using Labeler2" at the end of this appendix. 

To use the macro, simply Open Labeler2.xls it will appear on screen and then Hide itself. It installs a new menu command, "Add Data Labels..." in the Chart menu. To view the workbook, containing the macro and two sample charts. Unhide the workbook. 

To add data labels to a data series, click on the chart (you can pre-select the data series or choose it later in the dialog box). Choose "Add Data Labels..." in the Chart menu. This will display the Apply Data Labels dialog box. Choose the desired options and the range of cells on die worksheet that contain the data labels, then press OK. 

---