Charts - question on pie and bar charts

[tcanelli]

I read in the documentation that the pie charts use rows of data; but what if I want the pie to show me a breakdown of columns?

See pics attached. I would like to show the age counts in a pie chart, not bar chart.

Also, with the bar charts is it possible to get the value to display in the bar? We can get value or % to show in pie; would be helpful in the bar charts as well since this will be displayed on a large screen for the room to monitor changing totals in real time.

Currently the data for this is a view built in sql