Figure Data Sheet

Figure 21-34. Set Data Labels dialog

1tfn 1

'ei Labels

Copy Fcrmstting Cancel

LVnv OnfccflmProc Procwijri

"iAUWaaaim firiUlil» ^ibnUilnd

L P I "li-.ll- =1." 11- ■!■- =■ ("I..h r. F^ri-Pvwl Mwl FMIU ilr '-■ P-jiFaiw.

O £ ' Ci H rMUkd Mtnu l!0--n UNHltim QnWki Hhiu OnClnrtHhiii ~ rt.< s-^-it id TT Til. .1 ■ .r-.-. -i- "t.l "Hi P -I r SP« l-i-i- .I -I .■■-!..■> "P r "Cir P-l-i ¿P-0~itK[ "P.II "FUI PftHl» 4SH«. r. I- Mir ■-iV-vM;:! «nljfl.7t-ii -I--.L '-*-.L

l Rut

Next, create the dialog shown in Figure 21-34. We have used the RefEdit control, which simulates the Excel feature of choosing a range using the mouse. Unfortunately, this control is not documented in the help files. (You can get a list of its properties, methods, and events in the Microsoft Object Browser, but no help.) In any case, we are interested in only one or two properties, as shown in the upcoming code.

The LabelDataSeries procedure, which is called when the menu item is selected, should be placed in a new standard code module called basDataLabels. The Declarations section of the code module has some module-level declarations, which are shown in Example 21-10.

0 0

Post a comment