From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Creative use of sparklines in merged cells with axes

Creative use of sparklines in merged cells with axes - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Creative use of sparklines in merged cells with axes

- [Instructor] If you're about to create a visual image 2 of data on a worksheet, sometimes you'll create a chart. 3 I've got some data in columns A and B 4 covering a two year period from mid 2015 into mid 2017. 5 And since the data in question here 6 is surrounded by empty cells and worksheet boundaries, 7 I could simply click anywhere within this data 8 and press alt + F1 to quickly get a chart. 9 Now that may or may not be a great looking chart, 10 I'm not too fond of it myself, 11 but it does tell a story in a certain way. 12 But sometimes a better alternative 13 is what we call a sparkline. 14 And we see one here already in existence 15 for the data right here. 16 Let's talk about how to create this, 17 you might not be familiar with it. 18 I'm going to eliminate what we see in K3, 19 but before doing that, 20 notice that this is a visual representation 21 of these numbers. 22 Now, I don't think it's exactly obvious…

Contents