you're going to need graphs, and lots of them, but if you want to stay within Excel, the best way to do it is to create a ...

Would a scatter graph or a pie chart work better for ... Bar," "Gridlines," and "Headings" to make your dashboard look less like an Excel sheet and more like a professional data dashboard.