MENU

Fun & Interesting

Robust Dynamic Charts with Dynamic Arrays and Names with Jon Peltier

flexyourdata 947 4 weeks ago
Video Not Working? Fix It Now

Dynamic arrays are great for creating ranges that change shape as the data changes. Charts based on dynamic arrays will also change their source data to match the array. But it's not always that simple and there are important things you need to be aware of. Learn from world-leader in Excel charting and Microsoft Excel MVP, Jon Peltier. If you'd like to follow along, you can download the workbook here: https://peltiertech.com/RobustDynamicCharts.zip --- As well as being a world-renowned leader in data visualization techniques, Jon Peltier is the founder and owner of Peltier Technical Services, the author of the invaluable Peltier Tech Blog and a veteran Microsoft Excel MVP. You can learn more about Jon's work and read his blog on his website: https://peltiertech.com/ https://www.linkedin.com/in/jonpeltier/

Comment