Excel Chart from CSV Files


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.

Below I have expanded on the details:

I have attached an excel file that contains 3 sets of data that 'in the context' of this application have been imported from 3 different csv files.

The x-axis is populated from the first column of the csv data and the y axis populated from the second column. I have used the line chart format, but I would desire the chart type to be modified easily, maybe commenting the section of code?

There is a single chart for each set of data, then a chart with the combined set of data. Now here is the catch; the data currently has the same scaling in terms of the x axis values, but can the application incorporate the fact that the data imported from the csv file(s) could have different ranges for the x-axis, and still be able to plot several charts on one x-axis? The y axis values of course will have different values but I am figuring that the scaling issue here has more to do with the x-axis...

Another thing to note is that when the application imports the csv files it should be able to arrange the sets of data appropriately in the spreadsheet so that it is evident that they are different sets of data.

Also it should be able to plot the chart based on the number of sets of data that have been imported, ie. if 2 sets of data have been imported, then there can either be 2 single charts, or a combined chart with 2 different sets of data etc...


Beceriler: Visual Basic

Daha fazlasını gör: csv chart, plot csv excel, excel graph csv, chart csv, excel plot csv, csv excel graph, csv excel chart, plot csv file excel, chart csv file, csv chart excel, excel chart csv, charts csv, csv plot excel, excel plot csv data, create chart csv, excel data plot csv, plot csv data excel, create chart csv files, excel create graph csv, excel plot csv file

İşveren Hakkında:
( 27 değerlendirme ) Aberdeen, United Kingdom

Proje NO: #130468



Hello Sir. I can do this project for You. Please check Your PM.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(2 Değerlendirme)

Bu iş için 7 freelancer ortalamada $54 teklif veriyor


Hi, we have done some projects on GAF on VBA. We would be glad to help you with this one. Kind regards, SmartGuru

in %bids___i_period_sub_35% gün içinde75%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)

Hi, Check PM now ASAP. Thank you.

in %bids___i_period_sub_35% gün içinde40%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)

I can do this. Let me know.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)

I read the discription and it is something I've done many times before. I use to work in an R&D lab before becoming a free lancer and I wrote many a spreadsheet that did this very thing, I still have the code so it's Daha Fazla

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

hai we will do the job with in time and good quality. if u want i will give the sample. bye baa...

in %bids___i_period_sub_35% gün içinde75%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hello if the performer is not selected yet I can to make this job.

in %bids___i_period_sub_35% gün içinde32.5%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)