Quote:
Pepsione1 wrote:
That's a very good example Gord. However, the data file is built & exported by a independent program and I don't have any control on how the file is created.
Is there anyway to do the exact same thing you showed? |
This is the problem with trying to solve something like this (computer/computer app/etc) over e-mail.
I'm not sure "exactly" what currently exists (and in what format) or exactly what you want done, etc. When playing with databases that's pretty important.
As the other posters said Excel may not be the ideal solution or even any solution (if one of your requirements requires functionality that Excel doesn't have, such as, more than 64,000 rows, etc or needs Visual Basic programming especially if decisons/branching/looping/etc are required).
That said it is amazing what can be done in Excel. In your example, perhaps you could try the menu item "Data - Get External Data - Import Text File" or the query option in the same menu. Just for fun, I did this by saving some data in a text file format and used this import wizard to insert the data at the end of the column in the spreadsheet I attached in my last post. It pasted in and automatically updated the chart just as if you copied and pasted the data manually. Not sure if this is helpful though.
There are likely other possibilities but as I said above without having all the information it is difficult (if not impossible) to come up with a solution.
Not sure how many data points you want to plot but obviously your graph would get pretty crowded very quickly. There are ways to just plot the last "n" number of data points though.
Sorry I can't be more helpful ... good luck!