Bar Chart -Chart axis each data with equal length

[Nandakumar]

Hi,

I need a help on the attached chart.

I had created Budget vs actual chart with Revenue,Gross Margin & Netprofit.

I want Budget comparison of each data with same length (i attached ideal chart - which should be look like)

Instead three seperate charts,can i do in one chart

Please advise

 

[Hui]

I assume you want this ?

see attached file

 

[Nandakumar]

Perfect.Thank you so much.

Can you please guide me how you did this,it will be a great help.

I assume you want this ?
View attachment 75014
see attached file

 

[Hui]

Select each bar
Look at where the data is coming from in the Formula bar
Look at those cells and work out what it is doing

It is pro-rata ering the data based on the largest bar
But using the Original data for the Labels

 

[Nandakumar]

Got it.

Thank you so much.

Select each bar
Look at where the data is coming from in the Formula bar
Look at those cells and work out what it is doing

It is pro-rata ering the data based on the largest bar
But using the Original data for the Labels