The protocols are the same for Mac Excel and Windows Excel, and perhaps it’s time for a quick review. So I dusted off my MacBook Pro and tried it out.īottom line: There are several ways to make dynamic charts in Excel, and there seems to be no difference other than cosmetic in how they work between different versions of Excel, and between operating system.
Good question, and I wondered if he’d encountered some unexpected problem, perhaps a bug, in Mac Excel. A reader emailed to ask whether you could make a dynamic chart using OFFSET-function-based Names in Excel 2016 for Mac.