Hi!

I am looking for a software that can take dynamically updating data in excel worksheet every second and plot graphs from it.

Here is my working conditions:

1. Data supplied from the monitoring instruments is updated dynamically for about 300 (unique IDs) x5 (5 criteria for of the 300 unique IDs) =1500 columns each having about 400 rows.
2. This data is sorted as per priority into about 5x120=600 unique Ranges.
3. Each of these 120 sets of 5 ranges is grouped into a chart and about 30 charts (each carrying 5 series) are displayed on one worksheet i.e. total of 4 sheets and all the data coming in from the monitoring instruments to the same workbook.

I am able to run this data comfortably with the charts dynamically updating every 1-2 seconds for the first 60-90 minutes.
After that excel starts slowing down and takes about 20-25 seconds to plot the charts as more and more data comes in.

I was wondering whether:

1. There is any software that can take this data from excel and plot my dynamically updating charts faster (every second update?). Also I need to see atleast 30 charts dynamically updating on my screen at any given time.
2. Is there any software to convert my workbook to a .exe file and then run/ update my charts faster? I have seen softwares that claim to convert excel workbooks to .exe to protect against changes, but are there any to actually run a workbooks faster?

I am running Excel 2010 x64 with Windows 7 x64 with 6 GB RAM and i7 processor.

Regards,

Naira