| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formating Data Labels
Hi all
Im trying to update the values in a data entry form. I have set up a seies of labels and want to update tehm as in the following code. Im having trouble with the formatting of the numbers. Can I control the format of the caption text or do I need to use a different method?? If IsNumeric(Selection.Cells.Offset(0, 43).Value) = True Then Pv.Caption = Selection.Cells.Offset(0, 43).Value Pv.Caption.Text = Format("0.000") End If Regards Ian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How select all data points/data labels at once (to format)? | Charts and Charting in Excel | |||
| Chart Labels - Conditional Formating | Charts and Charting in Excel | |||
| Setting hover data labels to cells other than source data | Charts and Charting in Excel | |||
| Setting hover data labels to cells other than source data | Excel Discussion (Misc queries) | |||
| renaming data labels by different cells than source data | Charts and Charting in Excel | |||
Threaded Mode
