Graph Large Amounts of Data 2

[bsj0526]

I am acquiring measurements every minute for 1000 hours and need to graph the results so that I can analyze the results. I have started creating the graph in Excel, but there is a 32,000 data point limit. I could create 2 charts, each having half of the data, but I would like something a little more "slick" that I could scroll through and zoom in on short periods of time. Does anyone have any idea how to accomplish this?

Thanks in advance,
Brian

 

[IRstuff]

You only have 60,000 data points, so that's something that Excel can swallow. You would then need to wrap some VBA around the data with a couple of slider controls to make that happen.

TTFN

FAQ731-376

 

[KiwiMace]

Two things seem to jump out:

1. If you need to plot all of the points, you probably don't need such fine resolution. Make a copy and delete every second point with a macro (or someone might be able to suggest an easier way).

2. If you need the resolution, you probably don't need to plot all the points.

 

[electricpete]

You might try something like this:

http://home.comcast.net/~electricpete/eng-tips/PlotInteractiveR3.xls

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[flaggday]

Your data can span multiple Series on a single graph.

If your data is in A1:B60000, set SeriesA to cover cells A1:B32000, and SeriesB to cover A32001:B60000.

Edit the graph so that both series have the same color, dot type, etc, and for most purposes it's no different than if all the data was represented by a single series.

Some options like having Excel draw a best fit line won't work, but those same results can be simulated using other Excel functions.

 

[MechEng13]

bsj,

You can also set up an offset function tied to a slider bar. Name the range that you want to graph and use the offset function in the name range dialogue. I have used this for repetative date on equipment downtime. It allows you the ability to scroll through smaller sections of the chart at a time. I found a tutorial on it at

http://www.datapigtechnologies.com/ExcelMain.htm.

Found a lot of good excel stuff there that I was able to use every day.




Alan M. Etzkorn
Manufacturing Engineer
Wabash National Corp.

http://www.wabashnational.com

 

[bsj0526]

Thanks everyone for the suggestions. I ended up going with the example from here,

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246.

It is similar to the one MechEng12 suggested, but free.

Thanks,
Brian