From the course: Excel Data Visualization: Designing Custom Visualizations

Unlock this course with a free trial

Join today to access over 24,100 courses taught by industry experts.

Image overlay chart

Image overlay chart - Microsoft Excel Tutorial

From the course: Excel Data Visualization: Designing Custom Visualizations

Start my 1-month free trial Buy for my team

Image overlay chart

“

- [Instructor] All right, so let's kick things off with something that's a little on the easier side but still pretty unique and creative nonetheless, and that's custom image overlay charts. So in the Data_Visualization_Exercises workbook, head on over to that first green tab, the Image Overlay Charts tab, and we'll see what we're working with. And as you can see up here, we've got just a few data points to work with. This is basic fundraising results. We have a user entered value for dollars raised in cell A2. Got a goal of $10,000, and then dollars raised and percent to goal in column C and D, both of which are calculated based on A and B. And the idea here will be to create something that's a little bit more unique and a little bit more creative than your standard hundred percent stacked column. To do that, we're going to integrate our own custom graphics. So I've built out two examples here and inserted them into the worksheet. Got a thermometer and a thumbs up icon. And you can…

Contents