title: How to automatically extend the range of a chart using VBA?
body: <p>The structure of my document can be seen from the image below. I wish to build a timeline chart from columns A (excluding cell A1, it is crucial for the chart that this particular cell is not included), B and D. I am looking for ways to make the chart dynamic by using VBA so that new events added by the user will be automatically shown in the chart without having to manually change the range of the chart. </p>
  
  <p>The range doesn't have to change instantly/continuously -- as long as it changes when the macro behind the button "Create a New Event View" is clicked. When the user has more events to add to the table, she can just add the events into the table and by creating a new table and deleting the old one she will have an updated chart as well.</p>
  
  <p>The question is, how to pull this off?</p>
  
  <p><img src="https://i.stack.imgur.com/3IOdU.jpg" alt="enter image description here"></p>