Automate data labels
 

Is there a way in Excel 2003 to update data labels in existing Pie Charts.
Everytime I run a new report I have to delete old data labels and then format
my labels as needed. Typically the format I use is label value (%).

Automate data labels
 

Hi,

I take it you have custom data labels, because the regular ones showing
Value, Series Name, ... update to reflect the data range. If you have
customized your data labels manually, then instead of entering data into the
data labels create references to spreadsheet cells, this must be done
manually. Suppose the data labels you want are in the range D1:D5 then
select the first data label and type = on the formula bar and click on cell
D1 and press Enter. Repeat this for all the data labels.

A number of people have created Excel add-ins to do this for you: Google
"Excel Chart Labeler"
--
Thanks,
Shane Devenshire


"Jennifer" wrote:

Is there a way in Excel 2003 to update data labels in existing Pie Charts.
Everytime I run a new report I have to delete old data labels and then format
my labels as needed. Typically the format I use is label value (%).

Automate data labels
 

Okay I can do that, when I create these I will need it to pull the value and
percentage.
I typed in:
= refrence the cell with the value&" "&"("&=reference ell with % value&")"

This pulled in 2 (0.33) instead of 2 (33%). How do I make the 0.33 a
percentage format ?

"ShaneDevenshire" wrote:

Hi,

I take it you have custom data labels, because the regular ones showing
Value, Series Name, ... update to reflect the data range. If you have
customized your data labels manually, then instead of entering data into the
data labels create references to spreadsheet cells, this must be done
manually. Suppose the data labels you want are in the range D1:D5 then
select the first data label and type = on the formula bar and click on cell
D1 and press Enter. Repeat this for all the data labels.

A number of people have created Excel add-ins to do this for you: Google
"Excel Chart Labeler"
--
Thanks,
Shane Devenshire


"Jennifer" wrote:

Is there a way in Excel 2003 to update data labels in existing Pie Charts.
Everytime I run a new report I have to delete old data labels and then format
my labels as needed. Typically the format I use is label value (%).

Automate data labels
 

Hi Jennifer,

Modify the formula in the spreadsheet to read

= TEXT(A1,"0%")&" Your text here"

You can format the result in any cell using the TEXT function, its second
argument, which must be in quotes, can be an format code that is legal in
Excel, you can see what the codes are by using the help system of selecting a
format in the Format, Cells, Number tab and then clicking the Custom
category. The code appears on the Type line.
--
Thanks,
Shane Devenshire


"Jennifer" wrote:

Okay I can do that, when I create these I will need it to pull the value and
percentage.
I typed in:
= refrence the cell with the value&" "&"("&=reference ell with % value&")"

This pulled in 2 (0.33) instead of 2 (33%). How do I make the 0.33 a
percentage format ?

"ShaneDevenshire" wrote:

Hi,

I take it you have custom data labels, because the regular ones showing
Value, Series Name, ... update to reflect the data range. If you have
customized your data labels manually, then instead of entering data into the
data labels create references to spreadsheet cells, this must be done
manually. Suppose the data labels you want are in the range D1:D5 then
select the first data label and type = on the formula bar and click on cell
D1 and press Enter. Repeat this for all the data labels.

A number of people have created Excel add-ins to do this for you: Google
"Excel Chart Labeler"
--
Thanks,
Shane Devenshire


"Jennifer" wrote:

Is there a way in Excel 2003 to update data labels in existing Pie Charts.
Everytime I run a new report I have to delete old data labels and then format
my labels as needed. Typically the format I use is label value (%).