I have a CSV file that gets updated by an automated process once a day.
I am looking for someone to use ASP to read that CSV file, and output the data as a basic column chart using Google's Visualization API.
Example CSV and Resulting html file with bar chart is included.
## Deliverables
The CSV file is the result of two Excel pivot tables.
The top table contains monthly figures for **last year**. The bottom table contains monthly figures for **this year**.
I need the ASP script to read the CSV, and grab the data point for each month going back X number of months and plot them on an interactive chart using Google's Visualization API:
<[login to view URL]>
The number of months to go back must be a variable that I can change, but will never be more than 12 months.
The path/location of the CSV file must be a variable that I can change.
The last bar on the chart will always be a running total for the current month.
I have attached two sample files, both a CSV and what I would like the resulting HTML with chart to look like. In this example, the chart shows a 12 month history. The first two bars are November and December of last year, followed by January through October of this year.
NOTE: This CSV is not current. It was saved at the end of October. Had I saved a new CSV today, it would show some data for November, and the chart would only go back to December of last year.