At this point I want to create a chart from everything I have sent - it excel sheet will have 1 character column (x-axis) and 1 or more numeric fields to the right.

Download the sample chapters for MegaFox: 1002 Things You Wanted to Know About Extending VFP. One of the sample chapters is Chapter 6 -

Creating Charts and Graphs

It has been said that a picture is worth a thousand words. This is especially true when analyzing trends in financial applications. Viewing the data in a graphical format is usually more meaningful than merely reviewing a bunch of numbers in a spreadsheet. In this chapter, we will explore several mechanisms by which we can generate graphs to be displayed on forms or printed in reports. (Note: Creating graphs for display in web pages can be accomplished using the Office Web Components. This is covered in Chapter 16: VFP on the Web).