>Hi. Using VFP7 & Excel 2000. I have a point-of-sale system written in VFP. What I would like to create: an Excel bar chart for management that would move upward (for each sales division)as the day's volume increased.
>
> Mgmt could look at their chart and see "how's business today? Who is doing the best, the worst?"
Insert the required data into Excel, and create the graph. Use the "macro recording" feature to find out the required commands.
My article on Excel Automation includes a sample for creating a graph.
http://www.utmag.com/September2002/Page45.asp.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)