Thread: Chart From Csv Files

Originally Posted by definewebsites

Hi,

I would like to create a small VBA for Excel application that can do the following:

1) At a click of a button, import data from a Csv file, or more than one Csv file into the Excel workbook

2) Create a specified chart type from the data imported. The data in the Csv file will consist of only two columns. I would like to have the chart plot the values in the first column as the x-axis of the chart, and the values in the second column as the y axis.

3) Be able to plot more than one set of values on the same chart depending on the data that was imported, but still be able to distinguish the various charts from each other.

I have no idea how to go about it as I have no experience with VBA and Excel. I have tried searching on the forum, but couldn't come up with something in line with this.

I would appreciate all the assistance I could get.

Thanks

Hi,

it looks as though you have assigned yourself an ambitious project.

http://www.excelforum.com/showthread.php?t=584092 has pointers to various tutorials and learnings, for Excel and for VBA.

select View, Toolbars, Control Toolbox to enable you to set your Button.

select Tools, Macro, Record New Macro, and go through the actions of importing a .csv file and of generating a Chart to see the code required, together with what a tutorial shows this will be useful.

good luck with your project, I guess you will have many questions about the various functions as you progress.

---