Using Number column totals in Charts on a dashboard

Hi, is there any way in which you can use total shown at the bottom of a numbers column to generate a chart to be displayed in a second screen or a dashboard?

I have tried many ways to see if this can happen but can’t quite find the solution.

Thanks