From the course: Excel VBA: Managing Files and Data

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Create a chart

Create a chart - Microsoft Excel Tutorial

From the course: Excel VBA: Managing Files and Data

Start my 1-month free trial

Create a chart

- [Instructor] When you create a report on a regular basis, you will often create charts of a specific type. In this movie, I will show you how to use Excel VBA to create a chart based on data that appears in an expected range. My sample file is 0501createchart and that is a macro enabled workbook you can find in the chapter five folder of the exercise files collection. The data that we will use for our vba code appears here in the March worksheet. And the idea is that we will plot the data in column B with B one as the series label and B two through eight as the series data. And again, the assumption is that whenever a workbook like this arrives, for example, this could be a weekly sales report, then we would always be able to run the same sub routine because we know where the data will be. So with that in mind, I'll press alt F11 to move over to the visual basic editor. In this code module I have the outline of a…

Contents