plotting a value within a range
I often refer to my method of creating graphs as "brute force Excel," meaning that you can make almost anything work in Excel, but it sometimes means getting a little creative. The method described in this post can be considered a prime example of brute force Excel, where I walk through the steps for turning tabular data into a value plotted visually within a range.