Dynamic charts let you change the chart according to user choice. As an example, you may update the chart when you change the scroll bar or click a button. With this online video of the No cost Excel training, I will demonstrate how you can lock cells or defend worksheets https://www.linkedin.com/pulse/powerpoint-educators-multimedia-presentations-classrooms-2nage