Hi, the way Mynda does the chart in the Dashboard Course, Lesson 5.14 does not work in my worksheet (see attachment). I do get #Ref! errors with the INDEX...MATCH... formula and if I want to change the formula in the Select Data Source edit dialogue it does not accept it. Any assistance on this? Thank you very much and merry Christmas to everyone!
Hello,
I see no error in the attached file, nor do I see any index and match formulas either.
Merry Christmas!
Hi Marcel,
The INDEX formulas in the name manager, Chart_Dates and Chart_NAV, have the MATCH function in the column_num argument, it should be in the row_num argument.
Mynda
P.S. I've moved this question to the Dashboard course forum instead of the free Dashboard & Charting forum. That way I'll see it sooner and answer it more promptly.
Thank you Mynda, got it!
