Hello,
Excellent article. The best part was adding the F sign in the Axis. ppriciate your efforts in documenting the steps.
Discussion on:
View:
Show:
This is great and a straightforward way to get to the outcome. Thanks!
You can hid the lower bar simply by selecting the lower bar and setting the fill color to "no fill" and the border color to "no line." The lower bar is now hidden. Almost no effort! Sometimes the simple solution is not obvious.
This could be done with a High-Low-Close chart, using an Average value and label as the close, if that was info you wanted to show.
Susan, love your column; I've been following it for a couple of years.
Is there a reason why you cannot change the fill and border of the chart in figure B? I am not clear of the benefits of a third column, noting the difference between column B and column D.
Is there a reason why you cannot change the fill and border of the chart in figure B? I am not clear of the benefits of a third column, noting the difference between column B and column D.
I just went back and completed the chart according to your instructions. When you see the charts side-by-side the reason for the third column becomes clear.
What I wasn't seeing was that the red column in figure B was nowhere near to being correct. Although it starts in the right place it ends somewhere around 60 instead of at 41 (as it says in the chart).
Once again, great column, great tip! Thank you for being here with all your help.
What I wasn't seeing was that the red column in figure B was nowhere near to being correct. Although it starts in the right place it ends somewhere around 60 instead of at 41 (as it says in the chart).
Once again, great column, great tip! Thank you for being here with all your help.
"you might be wondering how to display the degree symbol " There is a much simpler method than finding, copying and pasting a symbol. Simply put your typing-curosr where you want the degrees symbol to appear, hold down the ALT key and type 248 on the numberic keypad. This is useful for other symbols too. ALT248= , ALT234=?, ALT230= , ALT234=?, ALT241=.
To enter the degree symbol (), press and hold the key while entering the digits "0176" on the numeric keypad.
Elegant solution for many uses, thanks for the tip about the axis formatting, BUT... the chart doesn't work for negative numbers. If the low was -10 and the high was 45, the column shows 0 to 55. If the low was -10 and the high was -5, the column shows 0 to 5.
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
