Dynamic Charts Using Dynamic Arrays | Jon Peltier

SESSION TRACK:
Excel

SESSION OUTLINE:
In Excel, a Dynamic Array Formula (DAF) can change the size of its spill range based on the result of its calculations. It is possible for a chart's source data range to adjust to a DAF's changing spill range, in much the same way that a chart can adjust to the changing size of a Table. But this only works if all chart data comes from the same DAF. Sometimes if the spill range is too large or the chart data is too complicated, the dynamic behavior breaks down. And sometimes simple, seemingly unrelated actions cause the linkage to break. This presentation by Microsoft MVP and charting legend, Jon Peltier, will describe what can go wrong, and how to work around the problems.

SPEAKER PROFILE:
Jon Peltier is a master of leveraging the power of Excel to produce and simplify complex solutions in engineering, finance, and marketing. His background includes Statistics, Total Quality, and Six Sigma, and he knows more about Excel charts than practically anyone. Jon has been a full time Excel developer since 2004, and has received Microsoft’s Most Valuable Professional award for Excel every year since 2001.

Connect with and follow Jon online at:

• Website: https://peltiertech.com
• Twitter: https://twitter.com/PeltierTech

TENTATIVE AGENDA (subject to change, all times listed are in Pacific Time):

• 8:45am Teams Meeting opens to attendees to begin joining
• 9:00am-9:05am Welcome and meeting overview
• 9:05am-10:05am Feature Presentation
• 10:05am-10:10am Meeting Wrap-up

REGISTRATION:
This meet-up will be hosted on Microsoft Teams, and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the Teams Meeting link.

JOINING THE EVENT:
Attendees can join the Teams Meeting starting at 8:45am on the day of the event. The link will be visible only if you RSVP beforehand.

Once the event gets underway at 9:00am, we ask that attendees make sure they are on MUTE, so background noise and distractions are minimized.

During the presentation, attendees can type questions and comments into the chat area, which will be monitored by the event hosts. There will be time for Q&A at the end, where attendees can un-mute their mic and even share their video to ask questions.

**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.

A link to the recording will be posted here on the event page and on the Excelguru social media channels once it is available (usually a day or 2 after the event).