Graphing - Reference isn't valid with dynamic range

[ironfelix717]

Under what circumstances would Excel refuse a correctly typed named range in a combination line plot graph?


Named range:
Screen Shot 2019-05-05 at 7.53.40 PM.png


Correctly typed range reference:

Screen Shot 2019-05-05 at 7.52.27 PM.png


Resulting error:

Screen Shot 2019-05-05 at 7.52.35 PM.png



File is attached (stripped) for reference and changed to 'V2'.

Ideas welcome. Thanks.

[6StringJazzer]

Using named ranges in Series formulas is very non-intuitive.

Instead of 'LogAnalyzer.xlsx'!Boost_Range use Data!Boost_Range and it will work. However, when you save it Excel will automatically change it to 'LogAnalyzer.xlsx'!Boost_Range. I have never understood why it works this way.

[ironfelix717]

6StringJazzer,

Thanks so much. Charting in general is non-intuitive in excel. Very frustrating with the little annoyances like this.

Thanks again.

[6StringJazzer]

You're welcome, and thanks for the rep!

[romperstomper]

Your workbook is called LogAnalyzer.xlsm not LogAnalyzer.xlsx...