How to create arrow that grows with size of value

stbrooks13

New Member
Joined
Dec 9, 2014
Messages
40
I have a graph that I need to recreate from a vendor. Only I don't know how they created the arrow that grows with the size of the value. Take a look at the linked image, any ideas?

https://drive.google.com/open?id=1OJd86ejvZRjV4c_j2AZE5XFuGhNgDVhZ
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
35,764
Office Version
365
Platform
Windows
Difficult to tell from an image, but one possibility is that they used shapes, in conjunction with VBA.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,692
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
It could have been made with something like Tableau, but you can create a bar chart in Excel and then just copy and paste an arrow shape onto the chart series to achieve something similar.
 

Watch MrExcel Video

Forum statistics

Threads
1,089,766
Messages
5,410,303
Members
403,309
Latest member
chaithra

This Week's Hot Topics

Top