madocar Member Sep 5, 2016 #1 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: Sep 5, 2016
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
Hui Excel Ninja Staff member Sep 6, 2016 #2 You are close You need to add another series like this: 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 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 5.4 KB · Views: 10 chandoo stacked bar.xlsx 115.8 KB · Views: 11
You are close You need to add another series like this: 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 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
madocar Member Sep 6, 2016 #3 Hi Hui, this is not the first time when you helped me. Thanks a lot I really appreciate your help