Include Data label for just bars, but not line

NathanDorsch

For a bar and line chart, is there a way to have data labels for just the bar - but not the line?

MarkSnodgrass

In the Chart Properties, under the data label settings, you can choose if you want line and bar, line only or bar only.

NathanDorsch

Also... it doesn't appear I have the option to adjust the text color.... the only option is to select the fill box, which doesn't look very asthetic.

MarkSnodgrass

In the Chart Properties, under the data label settings, you can choose if you want line and bar, line only or bar only.

NathanDorsch

Thanks @MarkSnodgrass How do I adjust the text color? It only shows up as black (which doesn't show well on a dark black bar).

MarkSnodgrass

Some chart types have a setting for the text color to be complimentary, but it doesn't appear that the line + bar chart type has that setting. Unfortunately, you are stuck with changing the other colors or looking into a different chart type.

Patricia_Zavisky

Hi in a multiple line chart is it possible to have one line with data labels and the other without any data labels?