Dynamically Generate graph in an excel file from a .csv file [URGENT]

**pushkarjajoria** · 06-14-2013, 05:39 AM

[URGENT]
Hi,
I am doing some complex computations on some files to generate a result.csv file of the format

FileName,Val1,Val2,Val3,Val4....Val8
testFile.zip,15,25,......,11
testFile2.zip,17,29,....,24

I keep adding new rows in result.csv.

Can excel dynamically copy the data from result.csv and generate a bar graph from it such that when i add new rows in result.csv it is reflected here in the graph?

Thanks in advance
Pushkar

**dilipandey** · 06-14-2013, 05:51 AM

Hi Pushkar,

welcome to the forum.
That result.csv will be one single output file and the same file always where results will be appended.. correct ?
Can you upload a sample result.csv and I guess we can have dynamic range for the bar graph ?

Regards,
DILIPandey
<click on below * if this helps>

**pushkarjajoria** · 06-14-2013, 06:36 AM

hi dilipandey,
Thanks for your reply.
I have uploaded a sample csv file.

NOTE: THE NUMBER OF COLUMN ARE NOT FIXED AND NEW ROWS ARE ADDED DYNAMICALLY.