How to make arrow size change with cell value?

[excel_stuff]

Dear listers,

I would appreciate help with this. I have added an upward/downward arrow in a cell using an Excel symbol. I would like the height and fatness of the arrow to change with the value of a cell. So if say the value of cell A1 changes from 10 to 50, then I would like the arrow to become proportionately taller and fatter (values range between 0 and 100). Any help would be appreciated.

Thank you!

 

[Faseeh]

Plz Try this in Worksheet1 Code:

Private Sub Worksheet_Change(ByVal Target As Range)
ScreenUpdating = False
Worksheets("sheet1").Activate
Range("A1").Font.Size = 10 + Round(Range("B1") / 5)
ScreenUpdating = True
End Sub

 

[excel_stuff]

Thank you, Faseeh. Much appreciated. This works for the size but not for fatness. Could we do something like whats on this webpage? http://ccgtools.england.nhs.uk/ccgoutcomes/html/atlas.html

Thank you
Shehzad

 

[excel_stuff]

P.S. It would be ideal not to have macros in the file but perhaps there is no way around it? Thank you.

 

[bobhc]

You will not do this without VBA.


.

 

[excel_stuff]

Thanks. I am happy to use VBA then.

 

[Faseeh]

Can you provide screen shoot of what you are looking for. On my pc the website keep showing this:



If you can show 2-3 pics showing how fastness increases then it will be helpful.