You could program something in VBA to do it for you.. I don't think I've heard anyone on HN refer to VBA as "magical".

(It does definately have a deficiency of ponies)

There is no need to use VBE for Barcharts when values are in Excel rows.

Just type f12, after highlighting the content; or insert chart from contextual menu (right click)