From the course: Excel Data Visualization: Designing Custom Visualizations

Unlock this course with a free trial

Join today to access over 22,500 courses taught by industry experts.

Automation with OFFSET and COUNTA

Automation with OFFSET and COUNTA - Microsoft Excel Tutorial

From the course: Excel Data Visualization: Designing Custom Visualizations

Start my 1-month free trial Buy for my team

Automation with OFFSET and COUNTA

“

- [Instructor] The next demo is one of the most important exercises in the entire course and it's about automating charts using OFFSET, COUNTA, and named ranges. Now the reason this lecture is so important is because functions like OFFSET and COUNTA are the basic building blocks to creating truly dynamic charts and graphs. Basically, they allow you to create fluid, dynamic chart source data rather than traditional fixed arrays, which really lets you bring your visualizations to life and integrate some much more advanced functionality. So head to the automatic chart updates tab, and as you can see here we've got a simple data set, two columns, date and temperature. And let's say my job is to update a trending temperature chart with every day that I collect new data. What you could do is select cell A1 through B24 and insert a line chart just like normal, and that's totally fine. The only challenge is that as you add more days worth of data and manually enter new temperatures, the chart…

Contents