Hello,

I am building a relationship map in excel and need a way to quickly format all of the lines on the scatter chart. I've started with this post regarding how to format all of the objseries in a series collection (http://www.excelforum.com/excel-char...cel-chart.html). It works well but I don't need it to format every line. I want to be able to format each line representing a weak relationship one way and every line representing a strong relationship another. Do I need to name the ranges in my spreadsheet and then refer to them in the code?

For reference, the relationship map I am building is similar to the one found here. http://chandoo.org/wp/2014/08/13/net...ionship-chart/

Thanks!
RVAExcelMonkey