Is there a way to make a chart sheet dynamic without using VBA? Like for example use defined name and the index formula.
For example =A1:INDEX(B1:B2;E11)
Someone made a workbook that only works for windows and not mac, so i try to figure what's wrong and how I can fix it...
Bookmarks