Change text orientation in a cell without VBA

SerenityNetworks

Board Regular
Joined
Aug 13, 2009
Messages
96
Is it possible to change text orientation in a cell without using VBA? For example I have an arrow character (↑) in A1. If B1 = NNE then I'd like the orientation of A1 to be -22 degrees. I can't see that the TEXT function or Conditional Formatting can help me (correct me if I'm wrong), so is there any method for manipulating the text orientation of a cell in some other manner besides using VBA?

Thanks in advance,
Andrew
 

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
2,660
If you can make do with -45 degrees instead of -22, format A1 as Wingdings 3 and enter :
=IF(B1="NNE",CHAR(35),CHAR(38))
 

thisoldman

Well-known Member
Joined
Jan 5, 2014
Messages
1,073
Perhaps this will be helpful. There are eight arrow symbols in Unicode, set at 45° intervals.

UNICHARDecimal
8593
8599
8594
8600
8595
8601
8592
8598

<tbody>
</tbody>

The formula =UNICHAR(8599) produces "↗". Different font faces have different arrows—Calibri seems to be a better choice than many.

People have difficulty judging angles: we overestimate acute angles, underestimate obtuse angles, and we are not at all good at estimating the tilt of an isolated line. Do you need to be so exact, distinguishing between NNE and NE?
 

SerenityNetworks

Board Regular
Joined
Aug 13, 2009
Messages
96
Thanks. I should have mentioned that I already have covered the eight principle points of the compass using the Calibri arrows. Since I'm graphing by hour, with close spacing, the difference between NNE, NE, and ENE will be noticeable. My goal is to be able to display the 16 principle points of the compass. I need to be able to do it without VBA. I've not found any fonts that provide 16 arrows. I should mention that I don't have to use arrows. An image, such as a dot with a trailing line would actually be better, but I'm okay with using arrows. At least arrows got my project started.

I've seen other threads describing different methods of displaying the compass points in a cell and in a graph. Most are pretty involved and many won't work for my particular use. That's why I wondered if I could just modify the text orientation with a formula. It would be so very easy. If I could use VBA it would also be easy, but that's not an option.

Thanks again,
Andrew
 

thisoldman

Well-known Member
Joined
Jan 5, 2014
Messages
1,073
I don't believe there's an easy and cost-free way without VBA or without the tedious chore of setting up linked images. I tried sparklines, but I can't get them to work.

The font Omnidirectional Arrows JNL appears to have the symbols, but it's $29 US.
 

Forum statistics

Threads
1,081,981
Messages
5,362,538
Members
400,679
Latest member
alecalec202

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top