From the course: Excel Data Visualization: Designing Custom Visualizations

Unlock this course with a free trial

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

Custom gauge chart

Custom gauge chart

- [Instructor] This next demo is a fun one, and it's a good example of how to combine two very different types of charts together to create something totally brand new and unique. So, in this case, we're actually going to be combining a doughnut chart with a scatter plot, of all things, to create a gauge and needle effect. So, that type of gauge chart visualization can be a really nice, really simple way to show where a given value falls along a certain scale. So, in the gauge chart tab, you can see I've put some objects in place to start to create a little bit of a template. These shapes will just create almost like a background effect for a gauge, and these text boxes will just align with different points along the edge of the gauge. So, I've got a few placeholder columns, here. I've got chart value in cell A2. This is the user entered value that you'll be plotting on a chart. It's really only one value that's going to be shown, and then a max value in cell B2. In this case, we're…

Contents