How to build a simple dynamic chart

Tip: How to build a simple dynamic chart

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?

Duration 
3:56
Author 

Related shortcuts

CtrlC

C

CtrlT

T

CtrlSpace

Space

Alt

Leave a Reply

Your email address will not be published. Required fields are marked *