From the course: Excel: Charts in Depth

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Create graphic-in-cell charts with sparklines

Create graphic-in-cell charts with sparklines

From the course: Excel: Charts in Depth

Start my 1-month free trial Buy for my team

Create graphic-in-cell charts with sparklines

“

- [Instructor] We're looking at a worksheet called Sparklines. In our chapter 10 exercise file. We got some data on the screen, Profits by Region. Some of these are negatives. We see the reds here, those are negative entries. We'd like to show, not necessarily a full fledge chart here, but just a quick indication of the Column, and in these cells here, what actually is happened, is there a trend here. Let's show the data in a visual way. Sparkline often is a line but it can also be a column, and there's a third option called Win-Loss, which will see momentarily. We begin the process by either highlighting the destination sales or the source data, either way, we'll go to the Insert Tab on the Ribbon, and off to the right you'll see Sparklines, and there's Line, the Line option. Many charts placed in single cells, each representing a row of data. Let's click it. It asks for the source data, It's the data right…

Contents