A reader emailed to ask whether you could make a dynamic chart using OFFSET-function-based Names in Excel 2016 for Mac.Good question, and I wondered if he’d encountered some unexpected problem, perhaps a bug, in Mac Excel. Bottom 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.The community helps answer your product questions with responses from other knowledgeable community members.
A bit more complicated is to use Excel’s Names to define the series data for your chart.
The protocols are the same for Mac Excel and Windows Excel, and perhaps it’s time for a quick review.
This exercise was done completely in Mac Excel 2016, and other than not knowing a few of the shortcuts I use everyday, it was not very different from working in Windows Excel 2016.
After you create a chart, you might have to change its source data on the worksheet.
To incorporate these changes in the chart, Microsoft Office Excel provides various ways to update a chart.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.