American Airlines Group Inc (AAL): Chart stuff for Name Manager >>&gt...

Reply Private New

Next 10 Prev Next

Send PM Follow Ignore

Followers	62
Posts	7863
Boards Moderated	0
Alias Born	12/14/2004

JLS

Re: None

Monday, 10/07/2019 5:07:48 PM

Monday, October 07, 2019 5:07:48 PM

Chart stuff for Name Manager >>>

Sorry for the large sixe, but you have to be able to read it without errors.

See that green Chart Tools tab at the top of Excel for Windows? I don't have a clue what it looks like for Apple Excel, but that's where everything is entered for charts in either equation form or value form in Excel for Windows. Pay attention: that green tab only shows up after you select a chart. That barely visible white line around the chart, and the green tab, indicates I selected the chart.

For the SR chart, the only named ranges you need are in the top three yellow cells: SR_Range for cell C7, SR_Weeks for Cell C8, and SR_Basis for Cell C9. You've already done SR_Weeks. Use the same process to name the other two cells. I'll give you the data for those later.

We can start the SR chart after you get all that done.

All of the data and calculations for both charts is on that SR_CP sheet (though the OHLC data for the equations on that sheet were read from the stock symbol sheet and placed on the SR_CP sheet).