It turns out that the screwed up charts were a result of having
some cells containing a space in the columns being charted. Not sure
why Excel works that way, but I imagine without apply column
formatting, that it could not determine the data type of those
cells.

Hope this helps someone else avoid this problem. Alan