Graph Large Amounts of Data
Graph Large Amounts of Data
(OP)
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
Thanks in advance,
Brian





RE: Graph Large Amounts of Data
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Graph Large Amounts of Data
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.
RE: Graph Large Amounts of Data
http://h
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Graph Large Amounts of Data
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.
RE: Graph Large Amounts of Data
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
![[elk] elk](https://www.tipmaster.com/images/elk.gif)
Manufacturing Engineer
Wabash National Corp.
www.wabashnational.com
RE: Graph Large Amounts of Data
Thanks,
Brian