From the course: Excel VBA: Managing Files and Data
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create a chart - Microsoft Excel Tutorial
From the course: Excel VBA: Managing Files and Data
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…
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.
Contents
-
-
-
-
-
-
-
(Locked)
Create a chart5m 1s
-
(Locked)
Move a chart to a chart sheet3m 49s
-
(Locked)
Add or remove data series from a chart5m 48s
-
(Locked)
Export a chart as an image4m 3s
-
(Locked)
Create a line sparkline3m
-
(Locked)
Create a column sparkline3m 25s
-
(Locked)
Create a win/loss sparkline4m 34s
-
(Locked)
Delete a sparkline2m 12s
-
(Locked)
-
-
-