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 line sparkline - Microsoft Excel Tutorial
From the course: Excel VBA: Managing Files and Data
Create a line sparkline
- [Instructor] Even though computer screens have gotten larger and can show more data than ever, if you're designing a dashboard or a worksheet for everyday use, space is at a premium. In this movie, I will show you how to create a variety of sparkline, or small chart, which can summarize your data efficiently. My sample file is a 0505, line sparkline. And it is a macro enabled workbook, you can find in the chapter five folder of your exercise files collection. Edward Tufte, who is a graphic designer, created a type of visualization called a sparkline. Which he defined as a word like summary of data. In Excel, sparklines take the form of a small chart that appears within a worksheet cell. So my goal, is to create a summary in cell E1, of the data, that appears in the range B2 through B8. And I'll do that using Excel VBA code. First, I will press Alt-F11, to move to the visual basic editor. And you see here, that I have…
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)
-
-
-