Sep 26, 2014

Charts in Microsoft Excel are a great way of representing data graphically, but sometimes that data is subject to change and when it does change, we need our charts to change automatically too. The good news is you don’t need to use VBA to create dynamic charts. By converting the data from a normal range to a table and then creating a chart that gets the data from a table, when the table increases to include new data, the chart will too. For example, imagine you have the data below:

To convert this data to a dynamic chart, simply follow these 3 steps: Step 1: Convert the data to a table Click anywhere in the data. Go to the ‘Insert‘ tab of the Ribbon and click on Table. This will generate a pop up box asking the data for your table and whether your table has any headers. Some formatting will probably be applied. Step 2: Create a chart Again, click anywhere in the data and go back to the Insert tab of the Ribbon. This time, click the chart type you want to create e.g. column, line, pie, bar etc.

Step 3: Test your dynamic chart When any data is entered to the right or the bottom of the table, the table will automatically expand to include the data and the chart will do the same. In this example, we will type in sales figures for June as per the image below.