Hello I am new to the forum. I am attempting to create a chart that is dynamic to my needs. I will enter stock tickers in cells C2:C6 and that will populate data in multiple cells which I currently have hard coded for this sample. I want the chart to pull from the dynamic named ranges I created, "Date", "Metric_Name", "DebttoEBITDA". when I create the chart and use =Series(Metric_Name,Date,DebttoEBITDA,1) Excel tells me I am using an invalid argument, but I don't know what I'm doing wrong since I've never worked with dynamic charts before. Any help would be greatly appreciated as I've been fooling around with this for hours. Thanks!



Attachment 151127