BPGraph - Dynamic Graphing with Microsoft Excel
Do you ever have the need to quickly graph some data and look for trends,
make reports
or narrow in on a range of data? Then BPGraph might save you some time.
BPGraph is a simple Excel worksheet that uses named ranges and controls to quickly graph the data you paste into it. You can switch between columns of data and switch your ordinate (x) axis on the fly. I find it useful, and thought I'd stick it out on the web in case anyone else would like to try it.
Click on the picture below to download it! A short HOWTO is included on a secondary tab in the worksheet.
At this point, BPGraph does not use VBA, but it may in the future to do more error checking and to allow better customization of the user interface.
The information used in making BPGraph was gleaned from sources too numerous
to mention,
but all originated at www.mrexcel.com on
the forums. Thanks to all who contributed!
Import Large Files
Another handy utility I use quite often is this large file importer. I use it to import text files. The best part about it is being able to split files into various lengths to get around the graphing deficiencies in MS Excel. Note: to use this, you need to have macros enabled.
(C) Bryan Pryor, all rights reserved