In this video, we’ll look at how to build a simple dynamic chart in Excel.
First, let’s look at the problem we’re trying to solve.
Here we have monthly sales data. At the moment, we only have 5 months, but we’ll be adding more data over time.
Now, if I insert a column chart, everything works fine.
But notice that if I add new data, the chart doesn’t change…it still plots the original data.
To update the chart, I’ll need to expand the range manually
How can I make the chart automatically include new data?