J
jg167
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
I would like to show a graph (bar charts or ..) of 10 or 20 data points. But to make the demo more eye catching I'd like to run the application that generates this data in real time and have the bars or whatever, be growing. So I just need to have a way to push/pull new data into the range being graphed.
I could put it into a database and have excel strobe it out, but I have read somewhere that the fastest refresh setting for external data is about 15 secs and I want to do this 2-3 times per second.
I might be able to just have a script that runs continuously and re-reads a simple data file into the range, does that work?
Anyway this seems like something that would have come up long ago on much more complex data, so what are the existing solutions?
Operating System: Mac OS X 10.5 (Leopard)
I would like to show a graph (bar charts or ..) of 10 or 20 data points. But to make the demo more eye catching I'd like to run the application that generates this data in real time and have the bars or whatever, be growing. So I just need to have a way to push/pull new data into the range being graphed.
I could put it into a database and have excel strobe it out, but I have read somewhere that the fastest refresh setting for external data is about 15 secs and I want to do this 2-3 times per second.
I might be able to just have a script that runs continuously and re-reads a simple data file into the range, does that work?
Anyway this seems like something that would have come up long ago on much more complex data, so what are the existing solutions?