• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Bar Chart -Chart axis each data with equal length

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
 

Attachments

  • Chandoo_Try_16Jun21.xlsx
    32 KB · Views: 3
I assume you want this ?
75014
see attached file
 

Attachments

  • Chandoo_Try_16Jun21.xlsx
    37.3 KB · Views: 8
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
 
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
 
Back
Top