Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
On one tab, I created two named ranges: Dates and Values using these Refers to formulas:
='Using dynamic named ranges'!$B$3:INDEX('Using dynamic named ranges'!$B$3:$B$100,COUNT(
=OFFSET(Dates,0,1)
I then clicked on one of the columns and then changed the resulting series formula for your chart to:
=SERIES('Using dynamic named ranges'!$C$2,'ExpExchange-
Note the use of the workbook name to qualify the named ranges (instead of the worksheet).
On the other tab, I used a Table. Charts built from a Table will automatically grow and shrink as you add data.
ExpExchange-QuestionQ28325281.xlsx