We have a bespoke operating system written in (I believe) VB6 from which I have to produce KPI reports to Excel for some clients every month which is not a problem. I now have a client that wants me to visulise some of the data in PIE and Stacked Bar charts, our program guy says this can't be done automatically but then again he still thinks the world is flat

Does anybody know if this is possible in VB to tell Excel to do this based on the downloaded data.