• 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.

Difficult chart - combined

madocar

Member
Hello,

i would like to ask you for help. I need to create very specific chart. In attached file is example of the chart I need with all comments.
Could you help me please?

Thanks for any help


Post Moved by Mod
 

Attachments

  • chandoo stacked bar.xlsx
    112.2 KB · Views: 9
Last edited by a moderator:
You are close
You need to add another series like this:
upload_2016-9-6_10-53-50.png

Then set the fill and outline of the 53 in Bar 2 to none
Insert a Arrow somewhere on the worksheet and copy it
then select the Green point and paste
upload_2016-9-6_10-55-3.png

Remember that the arrow is 4 units wide and so if you want it to point to 53, change 53 to 53-4/2 = 51

see attached file
 

Attachments

  • upload_2016-9-6_10-51-59.png
    upload_2016-9-6_10-51-59.png
    5.4 KB · Views: 10
  • chandoo stacked bar.xlsx
    115.8 KB · Views: 11
Hi Hui,

this is not the first time when you helped me.
Thanks a lot
I really appreciate your help
 
Back
Top