Format a data label on a chart

**Aland2929** · 10-26-2012, 04:19 AM

Data is displayed on a chart based on the selection of an option button (Quantity or cost). If I select cost, I would like the data label to be formatted as currency but as a comma format if quantity is selected? I have attached a sample file.
Thanks in advance.

**Andy Pope** · 10-26-2012, 05:03 AM

As you have only 1 data label it's probably easiest to link the data label to a cell.

In a separate cell use this formula to create data label content.
=IF(Trigger=1,TEXT(F6,"#,##0"),TEXT(F6,"R #,##0"))

Select data label, select data label again, in formaul bar enter = and click cell containing formula.

**Aland2929** · 10-27-2012, 09:44 AM

Thank Andy. I actually have two data labels (Actual & Budget) so I set up a similar formula for budget and it works perfectly. Is there another way when there are two data labels?
Thanks in advance.

**Andy Pope** · 10-28-2012, 07:31 AM

The other way is to use dynamic named range for the data series source. Then the data label will automatically use at number format of the underlying data.
This would mean referencing the source data, which needs to be number formatted appropriately, rather than the chart table you have currently.