I’m always on the lookout for new ways to show data visually. When you can see the problem data at a glance, it’s easier to to tell your story and convince people to help you / invest / solve the problem. Here are five charts that IMHO are very visual. They’re visual in that out of specification points, high and low points, etc. are highlighted and easy to see.
They’re created by
- Combining line charts with column charts / area charts
- Using calculations to calculate when values are out of specification and plotting these points as a new series (using #N/A)
- Using data labels on specific data points
- Using minus 100% percentage error bars to create vertical arrows
I’ll be posting the how to do these over the next couple of weeks, but you can download these 5 visual line charts and see if you can work it out for yourselves.
Hope it helps