different Label Number formatting in Line and clustered Bar chart

[RolinMartis]

Hi Team,

I have a line and clustered bar chart, I need to give different number formats to the labels.

Bar chart  label is headcount so it should be as it is  and Line chart should be in Millions.

Currently if i select auto it is giving weird format . Please find below the snipping.

I want the bar to show 5000, 4600 etc and Line to show 123M, 345M etc

Can you help me with this.

Regards,

Rolin

[amitchandak]

@RolinMartis , You have a display unit option. You can check to customize the series option and you should be able to do it for both of them separately

[RolinMartis]

@amitchandak  The display unit is changing the fomat for both the labels. Under Data labels I do not see a option to select Headcount and expense separately and do the different formatting for line and stacked column chart visual

[Fowmy · Accepted solution]

@RolinMartis 

If you scroll a bit down on the Data Lable formatting section you will find Customize Series option, turn it on and you will get to choose each series to select the required formatting.

[RolinMartis]

@Fowmy ,

I found it now, It works just the way i need.  Thanks alot for explaining in detail.

Regards,

Rolin