ExcelBanter - Data Labels

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Data Labels (https://www.excelbanter.com/charts-charting-excel/177488-data-labels.html)

jules 2008

Data Labels

I am working with stacked bar charts. In one series, the fill is black. I
want to make the data label numbers white but leave the data label background
black. Can I do this?

Andy Pope

Data Labels

Hi,

You should be able to format the data labels font to be white and set
the background to transparent. Just double click the labels to display
Format dialog and then select the Font tab.

Cheers
Andy

Cheers
Andy

jules 2008 wrote:
I am working with stacked bar charts. In one series, the fill is black. I
want to make the data label numbers white but leave the data label background
black. Can I do this?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

All times are GMT +1. The time now is 04:49 PM.