From the course: Excel: Charts in Depth
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Use a table as source data for a chart
From the course: Excel: Charts in Depth
Use a table as source data for a chart
- [Instructor] On this worksheet called "Chart from Table," we're seeing a column chart, a clustered column chart, based on the data from sales A1 over and down into F6. And you can tell by the entries in column A that we probably will want to add additional weeks here, every week we'll put in a new row here. Now it's not that difficult to expand the chart every time we put in new data, but what if the updates occur more frequently? What if it's every other day, or maybe every day? A chart of that type. But even here, you might get a little tired each time as we click on the chart we see how the data is highlighted, maybe even before we put in that new entry in row 7 we'll point to the corner here, I'll drag down. As I let go of this, keep an eye on the chart. We've made room for one more set of columns here for a different week. So how do we make this automatic? Let me back here, I'll press ctrl+Z. Let's turn this data…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.